Microsoft Excel
Rid Yourself of Fine Lines
Change the Cursor's Default Direction
Open Specific Spreadsheets at Start-Up
Fill in a Series of Dates or Numbers
Fractions or Decimals?
Back to Index
Rid Yourself of Fine Lines
To remove cell gridlines from a spreadsheet, Select Options from the Tools menu and click on the View tab. Under the Window options, uncheck the Gridlines box and click OK. The gridlines removed from your spreadsheet.
|
Change the Cursor's Default Direction
When you press the Enter key in a cell, Excel by default moves the cursor to the cell below it. To change this, open Tools > Options and click on the Edit tab. Change the direction of the selection movement from the drop-down list titled Move Selection after Entry.
|
Open Specific Spreadsheets at Start-Up
Excel can be started up with spreadsheets that you most frequently use. To do this, first open the spreadsheet you want to open at startup. Then click on File > Save As and locate the XLStart folder within the \Program Files\Microsoft Office\Office folder. Click the Save button to save this file in the folder. Next time you start Excel, this spreadsheet will automatically open.
|
Fill in a Series of Dates or Numbers
You can easily fill a series of cells with consecutive dates in Excel. First click a cell and enter the starting date in the default date format (month/day/year). Move the mouse pointer to the bottom right of the cell to get a small cross called the Fill Handle. Click and drag across the cells you want to fill with the dates. To customize the series, drag with the right mouse button and click on Series.
|
Fractions or Decimals?
Get better accuracy in fractions than Excel normally gives. You can specify the number of digits the denominator and numerator of a fraction can have. Simply click on the cell that has the value and click on Format > Cells. Under the Numbers panel, select Fraction from the Category list. Then select the required accuracy from the Type list.
|