|
| How can I customise the Quick Access Toolbar (QAT) in Microsoft Excel 2010? |
|
|
|
|
|
To customise the Quick Access Toolbar in Microsoft Excel 2010:
- Right mouse click on the Quick Access Toolbar in the upper right corner of the Excel 2010 window. A menu appears.
- Select Customize Quick Access Toolbar.
- In the Choose commands from dropdown list make your choice by selecting the command you want and then click Add.
- The command is added to your Quick Access Toolbar.
- Repeat steps 1 - 3 to add all the commands you wish to your Quick Access Toolbar.
|
|
|
|
|
|
| How can I Hide or UnHide rows or columns using Microsoft Excel 2010? |
|
|
|
|
|
To hide a row or rows using Microsoft Excel 2010:
- Select a cell or cells and press CTRL while holding down the 9 key.
- The row or rows containing the selected cell or cells are now hidden.
To unhide a row or rows using Microsoft Excel 2010:
- Select the cells containing the range of the hidden row or hidden rows and press CTRL while holding down the SHIFT and the (keys.
- The row or rows containing the selected cell or cells are now unhidden.
To hide a column or columns using Microsoft Excel 2010:
- Select a cell or cells and press CTRL while holding down the 0 key.
- The column or columns containing the selected cell or cells are now hidden.
To unhide a column or columns using Microsoft Excel 2010:
- Select the cells containing the range of the hidden column or hidden columns and press CTRL while holding down the SHIFT and the )keys.
- The column or columns containing the selected cell or cells are now unhidden.
|
|
|
|
|
|
| How can I format Sparklines in Microsoft Excel 2010? |
|
|
|
|
|
To format Sparklines in Microsoft Excel 2010:- Select the Sparkline graphical element in your data column. A Sparkline contextual tab in the ribbon section of Microsoft Excel. Sparklines have a gallery, similar to charts and tables where you can quickly choose and select a style and colour scheme.
- Using Show/ Hide options to enable points, as well as different colours on markers allows you to create more instant visual representations. Checking a point option will turn on or highlight that point for each sparkline.
- To change the colours of any or all individual point on your Sparkline, select the Marker Color option to the right of the Sparkline gallery.
- To change the colour of the Sparkline, select the Sparkline Color option to the right of the Sparkline gallery.
|
|
|
|
|
|
| How can I combine text from different cells using Microsoft Excel 2010? |
|
|
|
|
|
To combine text from different cells using Microsoft Excel 2010:
- Select the cell or new blank cell where you wish to display the combined text of different cells.
- In the formula field enter = followed by the cell number of the first cell text you want to add.
- Enter &" "& after each cell number you add to the forumla.
- For example if you wished to combine the text from cells B1, B2 and B3 into cell B5. Select the B5 cell and enter =B1&" "&B2&" "&B3 into the formula line to combine the text from these cells into B5.
|
|
|
|
|
|
| How can I copy and paste Formulas from a range of cells without changing absolute or relative references using Microsoft Excel 2010? |
|
|
|
|
|
To copy and paste Formulas from a range of cells without changing absolute or relative references using Microsoft Excel 2010:- Select the range of cells containing the formulas and press Ctrl while holding down the H key.
- In the Find what box, type the .= sign.
- In the Replace with box, type the # sign to change the formulas to text.
- Click Replace All and then click Close.
- Copy and paste the selected cells to the new location.
- Repeat steps 1 through 3, reversing the # and = signs to change the text to formulas.
- Excel copies and pastes your selected formulas from the range of selected cells without changing absolute or relative references.
|
|
|
|
