Name Box

Name Box

Get The Completed Workbook What Is The Name Box?   The Name Box has several functions. It displays the address of the active cell. It displays the name of the cell, range or object selected if this has been named. It can be used to name a cell, range or object...
7 Keyboard Shortcuts For File Menu Commands

7 Keyboard Shortcuts For File Menu Commands

  Here are 7 great keyboard shortcuts to quickly perform file menu commands. Ctrl + N Create a new blank workbook. Ctrl + O Open the menu to open a saved workbook. Ctrl + S Save the current workbook or open the Save As menu is the file has not previously been...
How To Find The Nth Item In A Comma Separated List

How To Find The Nth Item In A Comma Separated List

Let’s say you have a column of data and in each cell you have a text string which is a list of items separated by a comma. Something like the below table. Download Example File   How can you get the Nth item from that list? One solution would be to use text...
12 Keyboard Shortcuts For Quick Formatting

12 Keyboard Shortcuts For Quick Formatting

  Here are 12 great keyboard shortcuts to quickly format your data. Ctrl + Shift + ~ Apply general format. Ctrl + Shift + $ Apply currency format. Ctrl + Shift + % Apply percent format. Ctrl + Shift + ^ Apply scientific format. Ctrl + Shift + # Apply date format....