Tuesday, December 20, 2022

Tips to remember in Microsoft excel

 1.#REMEMBER#

Don’t forget the Ctrl+Page Down and Ctrl+Page Up shortcut keys for selecting the next and previous sheets, respectively, in your workbook. 

You can also click the Next Sheet and Previous Sheet button marked by the ellipsis (…). 

The Next Sheet button is the one with the ellipsis on the right side of the sheet tabs immediately left of the New Sheet button.

The Previous Sheet button is the one with ellipsis on the left side of the sheet tabs to the immediate left of the first visible sheet tab. If your workbook contains too many sheets for all their tabs to be displayed at the bottom of the Worksheet area, use the Sheet tab scroll buttons to bring new tabs into view (so that you can then click them to activate them). 

You click the Next Scroll button (the one with the triangle pointing right) to scroll the next hidden sheet tab into view on the right and the Previous Scroll button (the one with the triangle pointing left) to scroll the next hidden sheet into view on the left. 

You Ctrl+click the Next Scroll button to scroll the last sheet into view and Ctrl+click the Previous Scroll button to scroll the first sheet into view.


 2.#REMEMBER#

When quitting of Microsoft excel.

 Press Alt+FX or Alt+F4 on your physical or Touch keyboard. 

Select the Close button (the one with the x) in the upper-right corner of the Excel program window. 

 Click the Excel program button (the green one with the x on a partially opened book to the immediate left of the Save button on the Quick Access toolbar) followed by the Close option on its drop-down menu.


 3.#REMEMBER#

The options in the When Creating New Workbooks section of the popular tab of the Excel Options dialog box include only these four combo


1.     Use This as the Default Font.

2.     Font Size.

3.     Default View for New Sheets.

4.     Include This Many Sheets.


 4.#REMEMBER#


Don’t forget about the shortcut keys:

Ctrl+B for toggling on and off bold in the cell selection,

Ctrl+I  for toggling on and off italics, and

Ctrl+U for toggling on and off underlining for quickly adding or removing these attributes from the entries in the cell selection.

 

 

 

 


No comments:

Post a Comment