Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do i a apply range(autoformat) in non-adjacent cells?
Hi I am trying to apply a range between B6:N35 however whenever I
select B6 , i am told in Microsoft ,version4 page32 to hold the control button and select the other cells when i do that and try to apply Autoformat i get a error message, any advice would be appreciated? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do i a apply range(autoformat) in non-adjacent cells?
Referencing your subject line ... in Excel 97 (my ver), think I can
multi-select non-adjacent cells and apply normal formatting options (via: Format Cells). But the "Autoformat" option (via Format Autoformat) was not possible. Excel would display an error msg, saying the command cannot be performed with multiple selections. But .. your range "B6:N35" appears to be a single range, in which case Autoformat option should be available -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Brent from the Bahamas" <Brent from the wrote in message ... Hi I am trying to apply a range between B6:N35 however whenever I select B6 , i am told in Microsoft ,version4 page32 to hold the control button and select the other cells when i do that and try to apply Autoformat i get a error message, any advice would be appreciated? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do i a apply range(autoformat) in non-adjacent cells?
If you go to the first cell hold down the mouse button and drag your range to the last cell to select autoformat should work Alternatively click on the first cell, press the shift key, then click on the last cell yhen choose autoformat by clicking on cells with control, you are selecting lots of seperate ranges even tho the cells are next to each other, hence autoformat will not work -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=503625 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum column if multiple criteria are met in adjacent cells | Excel Worksheet Functions | |||
How do I apply a combo box to multiple cells in Excel so that it . | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
How do I apply a Function to a column of cells and change there va | New Users to Excel |