Essential and Quick Microsoft Excel Tips: Queue-Tips
Are you a beginner/intermediate Excel user looking to save time by staying away from the Ribbon and mouse while using Microsoft Excel? You will find these essential tips and shortcuts handy when having to navigate worksheets and format your Excel data.
- Quickly move between worksheets within a workbook
For smaller workbooks, you can always use keyboard shortcuts like
-
- (Ctrl) + (Page Down) – takes you to the next worksheet
- (Ctrl) + (Page Up) – takes you to the previous worksheet
But for larger workbooks with more sheets, right-click on the ‘triangle navigation’ buttons located on the left of the worksheet tab. You will now be able to choose a worksheet from the pop-up menu displaying the names of all the sheets within the workbook.
- Keyboard Shortcuts for fast data entry
To enter the current date into a worksheet in Excel: (Ctrl) + ;
To repeat data from the cell above: (Ctrl) + ‘ (single quote)
To create a SUM function for cells immediately next to where you are: (Alt) + =
- Display the Formulae
To list all the formulae within the worksheet: (Ctrl) + ` (grave accent- usually found next to #1). Formulae can also be displayed by clicking ‘Show Formulas’ under the ‘Formulas’ tab.
- Select All
This is one of the frequently used keyboard shortcuts where you can select all the data in the current range by pressing (Ctrl) + A. You will need to press it again in order to select the entire worksheet as intended. (Select All). This action can also be performed by clicking on the upper-left intersection of Column A and Row 1 and then selecting the cell formatting option you prefer.
- Easy Cell Formatting
After making a selection by your mouse or using (Ctrl) + A, you can now use these keyboard shortcuts to change the formatting of selected cells-
-
- To open the ‘Format Cells’ dialog box: (Ctrl) + 1
- Apply the currency format: (Ctrl) + $
- Apply the percentage format: (Ctrl) + %
Contact Queue Associates
Please contact Queue Associates (a Microsoft Dynamics Gold Partner) to learn more about our services related to supporting Microsoft OneDrive, SharePoint, and other solutions, including other applications in the Microsoft 365 suite and Microsoft Dynamics 365.
You can reach us by completing the form on our CONTACT page, or by calling us at the Queue office phone number for your local region (the U.S., as well as Global locations).
