Excel Tips

Back to Hints and Tips Index                                             Back to Main Index

Round Numbers to the Nearest Integer

To round numbers to the nearest integer or dollar. In Excel there are formulas that can help in this task.

Round (2000/2002/2003)

The formula ROUND rounds a number up or down depending on the number.

Click in a cell and type =round(number,number_of_digits)

For example =round(5.6,0) will be displayed as 6

                   =round(5.446,0) will be displayed as 5

Rounddown (2002/2003)

The formula ROUNDDOWN rounds a number down.

Click in a cell and type =rounddown(number,number_of_digits)

For example =rounddown(5.556,0) will be displayed as 5

Roundup (2002/2003)

The formula ROUNDUP rounds a number up.

Click in a cell and type =roundup(number,number_of_digits)

For example =roundup(5.556,0) will be displayed as 6

                    =roundup(5.321,0) will be displayed as 6

Paste Options Buttons (Excel 2002/2003)

When you paste text into a spreadsheet cell a Paste Options  button may be displayed. Click this icon and Excel will show options allowing you to change the formatting of the pasted text.

While some may find this convenient in case they want to change pasted text to match the formatting of the original cell, others find this icon annoying.

For those of us who find it annoying this is how to get rid of the Paste Options button.

1. From the Tools menu select Options.

2. Select the Edit tab.

3. Uncheck Show Paste Options buttons.

4. Click on OK.

Moving between Worksheets without using the mouse

Use the Ctrl Page Down and Ctrl Page Up keys.

Ctrl Page Down will move to the right and Ctrl Page Up will move to the left one worksheet at a time.
 

Deleting cells, Rows & columns

Place your cursor on a cell, row number or column letter and use Ctrl  -
 

Removing Border Lines

Place your cursor on a cell or highlight the cells and use Ctrl Shift -
 

Back to Hints and Tips Index                                             Back to Main Index