some tips to ms excel

**drunk_tiger** · 6th May 2008, 05:20 PM

Password protection for Excel Workbooks
To protect your workbooks, open the workbook in question and click on Save As on the File menu. On the Tools menu at the top right of the box that appears, click on General Options. Type the password to open text box. Click OK. Your workbook is now password protected.

Using conditional formatting
Your Excel spreadsheet should let you glean information from it at a glance. This can be done using formatting. Conditional formatting allows you to apply a particular format to a cell, depending on whether it fulfils a certain pre-assigned condition.

**drunk_tiger** · 6th May 2008, 05:21 PM

To apply conditional formatting to a range of cells, first select the range. Go to the Format menu and select Conditional Formatting. A dialog box opens up asking you to specify the condition under which you want the format applied. From the first drop down, select Cell Value Is. Then select the appropriate evaluator from the second drop down. For example, this may be “greater than”. Now specify the value that the items in the selected range of cells should exceed. For example, “2300”.

Once you have specified the condition, click the Format button in the Conditional Formatting dialog box. Specify the formatting you want applied. For example, you might want to make all text red, or fill those cells with a particular colour. When you are done, click OK. Excel will highlight all the cells whose value is above 2300 with the colour of your choice.

**drunk_tiger** · 6th May 2008, 05:22 PM

Inserting multiple rows into an Excel worksheet
You probably know how to insert a single row into a worksheet—right-click anywhere in the row below where you want the new row, and choose Rows from the Insert option. Now, if you want multiple rows, after inserting one row, press F4. Excel will insert a new row as many times as you press F4. You can also do this: Select as many existing rows as you want new ones, and then choose Rows from the Insert menu. You will get as many new rows.

Close all open workbooks
To close your active workbook in Excel, you can use Ctrl + F4. In case you want to close all open workbooks at the same time, hold down the Shift key as you display the File menu. This will give you a Close All option. Choose this option to close all your workbooks, after saving changes in each. But remember that this option is only displayed if you go to the File menu while pressing the Shift key, and not otherwise.

Working with multiple Excel worksheets
If you’re working on several worksheets in a workbook, having to use a mouse to switch between them can be a huge waste of time. To go to the next active worksheet, use Ctrl + Page Down. To go back to the previous one, use Ctrl + Page Up. To insert a new worksheet into the workbook, use Shift + F11.

Allow simultaneous editing of Excel 2007 workbooks by multiple users
You can enable different users to simultaneously edit an Excel 2007 workbook by setting up the workbook as “shared”. You then need to save the workbook on an allocated network share, from where users can access and modify the data.

**drunk_tiger** · 6th May 2008, 05:22 PM

Inserting multiple rows into an Excel worksheet
You probably know how to insert a single row into a worksheet—right-click anywhere in the row below where you want the new row, and choose Rows from the Insert option. Now, if you want multiple rows, after inserting one row, press F4. Excel will insert a new row as many times as you press F4. You can also do this: Select as many existing rows as you want new ones, and then choose Rows from the Insert menu. You will get as many new rows.

Close all open workbooks
To close your active workbook in Excel, you can use Ctrl + F4. In case you want to close all open workbooks at the same time, hold down the Shift key as you display the File menu. This will give you a Close All option. Choose this option to close all your workbooks, after saving changes in each. But remember that this option is only displayed if you go to the File menu while pressing the Shift key, and not otherwise.

Working with multiple Excel worksheets
If you’re working on several worksheets in a workbook, having to use a mouse to switch between them can be a huge waste of time. To go to the next active worksheet, use Ctrl + Page Down. To go back to the previous one, use Ctrl + Page Up. To insert a new worksheet into the workbook, use Shift + F11.

Allow simultaneous editing of Excel 2007 workbooks by multiple users
You can enable different users to simultaneously edit an Excel 2007 workbook by setting up the workbook as “shared”. You then need to save the workbook on an allocated network share, from where users can access and modify the data.

**drunk_tiger** · 6th May 2008, 05:23 PM

Create the workbook and add the data. Then, on the Review tab, select the Changes group, and click Share Workbook. You can select your options here. In the Changes group, you can also select Protect and Share Workbook, so that other users cannot turn off Change Tracking.

Saving the shared workbook will then prompt you about changes saved by other users. If you keep the shared workbook open, you can choose to be informed at specified time intervals about changes other users have made.

If changes that you are making to a cell conflict with changes made by other users to the same cell, you are prompted to choose the changes that you want to keep.

Distribute workbooks for editing; merge or consolidate changes
If you want to allow users to make changes to the data in a workbook, but want to control what changes are accepted in the final copy, you can distribute copies of the workbook to each user and then merge or consolidate the changes in each copy.

After creating the workbook, set it up as a shared workbook from the Changes group in the Review tab. Then, distribute copies of the workbook. After users have made the changes in their copies and sent them back to you, save all the copies to a common location and click Compare and Merge Workbooks.

You can also send copies of worksheets for separate data inputs and then collate these into a master worksheet. For this, each worksheet should have similar or identical layouts. Once you have received completed worksheets from each user, click Consolidate in the Data Tools group on the Data tab. You can choose to consolidate data by Position, Category, or 3D Formulas.

Matera the Mad · 26th May 2008, 12:19 PM

Nice, DT! I have to try to remember that multiple row insertion.

Excel can be a fun toy too, here's one silly trick. You put a random number generating formula in a lot of cells, then use conditional formatting to make them change color according to the generated number.

Download this file:
http://www.firefromthesky.org/files/pixilated1.xls

Open it, and press the F9 key on your keyboard. Do it again. Now hold the key down and go nuts.

This one is a little complicated. It adds up the sum of three random numbers for each colored cell...some days I just like wasting time.

umarzai · 5th June 2008, 10:25 PM

nice work drunk tiger

6th May 2008, 05:20 PM	#1 (permalink)
drunk_tiger WickEd SuNNy Join Date: May 2007 Location: nepal Posts: 2,352	some tips to ms excel Password protection for Excel Workbooks To protect your workbooks, open the workbook in question and click on Save As on the File menu. On the Tools menu at the top right of the box that appears, click on General Options. Type the password to open text box. Click OK. Your workbook is now password protected. Using conditional formatting Your Excel spreadsheet should let you glean information from it at a glance. This can be done using formatting. Conditional formatting allows you to apply a particular format to a cell, depending on whether it fulfils a certain pre-assigned condition. __________________

6th May 2008, 05:21 PM	#2 (permalink)
drunk_tiger WickEd SuNNy Join Date: May 2007 Location: nepal Posts: 2,352	Re: some tips to ms excel To apply conditional formatting to a range of cells, first select the range. Go to the Format menu and select Conditional Formatting. A dialog box opens up asking you to specify the condition under which you want the format applied. From the first drop down, select Cell Value Is. Then select the appropriate evaluator from the second drop down. For example, this may be “greater than”. Now specify the value that the items in the selected range of cells should exceed. For example, “2300”. Once you have specified the condition, click the Format button in the Conditional Formatting dialog box. Specify the formatting you want applied. For example, you might want to make all text red, or fill those cells with a particular colour. When you are done, click OK. Excel will highlight all the cells whose value is above 2300 with the colour of your choice. __________________

6th May 2008, 05:22 PM	#3 (permalink)
drunk_tiger WickEd SuNNy Join Date: May 2007 Location: nepal Posts: 2,352	Re: some tips to ms excel Inserting multiple rows into an Excel worksheet You probably know how to insert a single row into a worksheet—right-click anywhere in the row below where you want the new row, and choose Rows from the Insert option. Now, if you want multiple rows, after inserting one row, press F4. Excel will insert a new row as many times as you press F4. You can also do this: Select as many existing rows as you want new ones, and then choose Rows from the Insert menu. You will get as many new rows. Close all open workbooks To close your active workbook in Excel, you can use Ctrl + F4. In case you want to close all open workbooks at the same time, hold down the Shift key as you display the File menu. This will give you a Close All option. Choose this option to close all your workbooks, after saving changes in each. But remember that this option is only displayed if you go to the File menu while pressing the Shift key, and not otherwise. Working with multiple Excel worksheets If you’re working on several worksheets in a workbook, having to use a mouse to switch between them can be a huge waste of time. To go to the next active worksheet, use Ctrl + Page Down. To go back to the previous one, use Ctrl + Page Up. To insert a new worksheet into the workbook, use Shift + F11. Allow simultaneous editing of Excel 2007 workbooks by multiple users You can enable different users to simultaneously edit an Excel 2007 workbook by setting up the workbook as “shared”. You then need to save the workbook on an allocated network share, from where users can access and modify the data. __________________

6th May 2008, 05:22 PM	#4 (permalink)
drunk_tiger WickEd SuNNy Join Date: May 2007 Location: nepal Posts: 2,352	Re: some tips to ms excel Inserting multiple rows into an Excel worksheet You probably know how to insert a single row into a worksheet—right-click anywhere in the row below where you want the new row, and choose Rows from the Insert option. Now, if you want multiple rows, after inserting one row, press F4. Excel will insert a new row as many times as you press F4. You can also do this: Select as many existing rows as you want new ones, and then choose Rows from the Insert menu. You will get as many new rows. Close all open workbooks To close your active workbook in Excel, you can use Ctrl + F4. In case you want to close all open workbooks at the same time, hold down the Shift key as you display the File menu. This will give you a Close All option. Choose this option to close all your workbooks, after saving changes in each. But remember that this option is only displayed if you go to the File menu while pressing the Shift key, and not otherwise. Working with multiple Excel worksheets If you’re working on several worksheets in a workbook, having to use a mouse to switch between them can be a huge waste of time. To go to the next active worksheet, use Ctrl + Page Down. To go back to the previous one, use Ctrl + Page Up. To insert a new worksheet into the workbook, use Shift + F11. Allow simultaneous editing of Excel 2007 workbooks by multiple users You can enable different users to simultaneously edit an Excel 2007 workbook by setting up the workbook as “shared”. You then need to save the workbook on an allocated network share, from where users can access and modify the data. __________________

6th May 2008, 05:23 PM	#5 (permalink)
drunk_tiger WickEd SuNNy Join Date: May 2007 Location: nepal Posts: 2,352	Re: some tips to ms excel Create the workbook and add the data. Then, on the Review tab, select the Changes group, and click Share Workbook. You can select your options here. In the Changes group, you can also select Protect and Share Workbook, so that other users cannot turn off Change Tracking. Saving the shared workbook will then prompt you about changes saved by other users. If you keep the shared workbook open, you can choose to be informed at specified time intervals about changes other users have made. If changes that you are making to a cell conflict with changes made by other users to the same cell, you are prompted to choose the changes that you want to keep. Distribute workbooks for editing; merge or consolidate changes If you want to allow users to make changes to the data in a workbook, but want to control what changes are accepted in the final copy, you can distribute copies of the workbook to each user and then merge or consolidate the changes in each copy. After creating the workbook, set it up as a shared workbook from the Changes group in the Review tab. Then, distribute copies of the workbook. After users have made the changes in their copies and sent them back to you, save all the copies to a common location and click Compare and Merge Workbooks. You can also send copies of worksheets for separate data inputs and then collate these into a master worksheet. For this, each worksheet should have similar or identical layouts. Once you have received completed worksheets from each user, click Consolidate in the Data Tools group on the Data tab. You can choose to consolidate data by Position, Category, or 3D Formulas. __________________

26th May 2008, 12:19 PM	#6 (permalink)
Matera the Mad Maksa's Grany Join Date: Jun 2006 Location: in my computer Posts: 255	Re: some tips to ms excel Nice, DT! I have to try to remember that multiple row insertion. Excel can be a fun toy too, here's one silly trick. You put a random number generating formula in a lot of cells, then use conditional formatting to make them change color according to the generated number. Download this file: http://www.firefromthesky.org/files/pixilated1.xls Open it, and press the F9 key on your keyboard. Do it again. Now hold the key down and go nuts. This one is a little complicated. It adds up the sum of three random numbers for each colored cell...some days I just like wasting time.

5th June 2008, 10:25 PM	#7 (permalink)
umarzai Friendly Member Join Date: Mar 2008 Location: Peshawar(PAK) Posts: 53	Re: some tips to ms excel nice work drunk tiger

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Tips to look slim	shadenights	Tips & Advice	3	12th April 2008 04:58 PM
Health - Important Tips	shadenights	Tips & Advice	1	30th March 2008 07:22 AM
Tips for your feet	am_alive	Tips & Advice	0	26th March 2008 11:15 PM
Holistic Health Tips	shadenights	Health is Wealth	1	17th December 2007 03:05 PM
Essential Health Tips	shadenights	Health is Wealth	0	4th December 2007 11:58 AM