1. Entering Data into an Excel Spreadsheet Open a new spreadsheet. In the first row of column B (cell B1), type “January”. Before you hit enter, click on the fill handle, fill handle is the small black box in the lower right hand corner of the highlighted cell. (Note: If the fill handle is not […]
Microsoft Excel – 10 Things You Should Know Read More »
Ctrl Combination Shortcut Keys KEY DESCRIPTION CTRL+PgUp Switches between worksheet tabs, from left-to-right. CTRL+SHIFT+Plus (+) Displays Insert dialog box to insert blank cells. CTRL+PgDn Switches between worksheet tabs, from right-to-left. CTRL+Minus (-) Displays Delete dialog box to delete selected cells. CTRL+SHIFT+( Unhides hidden rows within the selection. CTRL+; Enters current date. CTRL+SHIFT+& Applies outline border
Microsoft Excel – Keyboard Short Cuts Read More »
EXERCISE: 1. Download this file. 2. Open it in Excel. 3. Go through the steps outlined below and perform each one using the downloaded material. Getting to Know Your Workspace in Excel Excel is a spreadsheet program that allows you to store, organize, and analyze information. While you may think that Excel is only used
Microsoft Excel – Basics Read More »