Categories：Excel Tips
-
223 Excel Shortcuts for Windows And Mac
Making full use of shortcut keys can greatly speed up our operation of the computer. Of course, the boss also likes employees who work faster. If you don’t want to be fired, I suggest you use it often until you are skilled. Shortcut Keys for General Functions Open options Alt+F+T ⌘+, Open help F1 ⌘+/ […]
-
Powerful Double-click In Microsoft Excel
In our daily work on Excel, you definitely use the mouse while operating the keyboard. Actually, some operations can be easily done with the mouse directly. So let’s get started to know the powerful double-click in Excel. Quickly Move The Selected Cell If you want to move your cursor to any top position quickly, we […]
-
How to Customize the VBA Editor in Excel
When using the VBA editor for the first time, the format settings of the editor are in the default state. Editor font, color, and other options may not be your favorite settings. This article introduces how to set the font and color of the VBA editor to make the editor more comfortable to use. Step1: […]
-
How To Create A Random Drawing In Excel
You should often see lottery draws in some TV programs, it randomly draws one from a large number of numbers. Today, we will use Excel to make a simple random drawing , which is very simple to create. If you do a activity about random drawing in the future, you can also use it. ok, […]
-
Useful Microsoft Excel 2016 Tips
We have shared many Excel tricks to improve your work efficiency in previous tutorials. But there’s a saying that goes: multi-skills are not pressure. So in this article, the author would still share with you guys useful and best Excel tricks. How to Highlight Nonworking Days in Excel Sheet? You need to prepare the date […]
-
How to Control the Number of Times the Same Content Is Entered in an Excel Cell?
Maybe you haven’t met this kind of situation before, but Skill is no burden, the author will introduce this in detail. come and start to learn! Step1: Open an Excel book and take Price as an example. Step2: Select the cells and go to Data Validation in toolbar. Click Settings window and choose Custom in […]
-
How to Freeze The First And Last Row in Excel?
When our Excel table is very long, we usually freeze the header row for browsing convenience. Freezing the header row is actually very simple, and people who often use Excel can do it. But what if you want to freeze the first and last rows at the same time? How to Freeze the Top Row? […]
-
How to Print a Long And Narrow Excel Table
Have you ever printed a long and narrow Excel sheet? It may takes a lot of paper to print such a form, but you will find it wasteful. Because most part of a piece of paper is blank. So today, the author will share you a useful method to print this kind of sheet. Step […]
-
How To Merge Multiple Excel Files Into One Workbook
When we counting some data, there may be multiple tables to count a variety of data, but the type of each table is the same. In order to facilitate access, it is necessary to merge multiple excels into one table, so that the data can be more clearly analyzed Statistics, but how to merge multiple […]
-
Create A Five-Star Rating System In Microsoft Excel
After often using some products or shopping online, we will judge the products or the shopping service, usually apply the five-star rating. We can give the number of stars according to our experience! In fact, you can also make a five-star rating effect in Excel. Let’s get started. Step 1: Frist, we need to prepare […]
