|
|
|
|
 |
Welcome to 123XLSX.com's Tips for using Microsoft Excel 2007 section.
Because there have been several releases of Microsoft Excel over the years with differing menu, ribbon, functionality and features. In an effort to help you make the most out of your version of Microsoft Excel, we have compiled a list of Tips and Tricks into several categories which are listed in the right hand menu.
To find tips which will help you get the most out of Microsoft Excel and improve your efficiency in creating documents and publications, select the category that applies to your version of Microsoft Excel.
If you have any further questions concerning Microsoft Excel, working with Excel spreadsheets, Excel macros or Excel Dashboard Reports or would like to learn more about 123XLSX.com, out products and services, please contact our Customer Services Department. Our service and support staff are on hand to assist you with any and all questions that you might have.
Questions from across all categories include:
|
 |
|
|
|
| How can I Hide or UnHide rows or columns using Microsoft Excel 2007? |
|
|
|
|
|
To hide a row or rows using Microsoft Excel 2007:
- 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 2007:
- 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 2007:
- 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 2007:
- 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 combine text from different cells using Microsoft Excel 2007? |
|
|
|
|
|
To combine text from different cells using Microsoft Excel 2007:
- 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 allow or limit users to edit changes using Microsoft Excel 2007? |
|
|
|
|
|
To share a workbook with other users using Microsoft Excel 2007:
- Select the Share Workbook icon from the Changes section of the Review menu option in the main menu.
- Select
- Allow changes
and click OK.
- Excel applies your settings to the workbook and allows changes to the workbook to be made by other users.
To protect a workbook from other users using Microsoft Excel 2007:
- Select the Share Workbook icon from the Changes section of the Review menu option in the main menu.
- Select
- Protect Structure and Windows
to prevent users from altering the workbook or select Restricted Access to specify a list of users and their access privileges.
- Excel applies your settings to the workbook and protects changes to the workbook .
To track changes made to a workbook by other users using Microsoft Excel 2007:
- Select the Track Changes.
- Excel now tracks all changes made to the workbook and highlights changes to show editing.
|
|
|
|
|
|
|
|
|
