Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting Data
I am running office 2008 which does not support macros. There are about 10
columns with each column having up to 250 rows of info. These 10 columns are unprotected but columns on either side are protected. Is there a quick way (keyboard shortcut?) to select the unprotected columns only in order to sort this data. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting Data
Assume the columns are F:O
then use 2008 equivalent of windows F5/ctrl + G (go to) and type in F:O and press enter -- Regards, Peo Sjoblom "ckane" wrote in message ... I am running office 2008 which does not support macros. There are about 10 columns with each column having up to 250 rows of info. These 10 columns are unprotected but columns on either side are protected. Is there a quick way (keyboard shortcut?) to select the unprotected columns only in order to sort this data. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting most recent data within several lines of data | Excel Discussion (Misc queries) | |||
Selecting non-adjacent data | Excel Discussion (Misc queries) | |||
Pivot charts - data disappear after selecting or data are static | Excel Worksheet Functions | |||
Selecting data | Excel Worksheet Functions | |||
selecting values from raw data | Excel Worksheet Functions |