Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Cleaning Up" Spreadsheet
I have a spreadsheet that goes over to column G and down to row 65. I'd like
to delete the rest of the rows and columns so that all the user sees are the fields I've populated and there's no H column or row 66. Is this possible and if so can you tell me how? THanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Cleaning Up" Spreadsheet
Click on the column identifier for column H, hold down <shift, press
<end, then <right-arrow, then release <shift - this will have highlighted all the columns from H to IV. Then click on Format | Columns | Hide OK. Then click on the row identifier for row 66, hold down <shift, press <end, then <down-arrow, then release <shift. All the rows from 66 to 65536 will have been highlighted, so then it's Format | Row | Hide OK. Hope this helps. Pete |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Cleaning Up" Spreadsheet
You can't actually delete the extra columns/rows. When you do, they will
just be replaced with new ones. What you could do, is Hide them. Select your rows/columns (holding down Ctrl-Shift-Down or Ctrl-Shift-Right may be faster). Right-click the selected area, then select "Hide". Users will be able to manually Unhide these areas if they wish, unless you protect the sheet. HTH, Elkar "SharePoint Newbie" wrote: I have a spreadsheet that goes over to column G and down to row 65. I'd like to delete the rest of the rows and columns so that all the user sees are the fields I've populated and there's no H column or row 66. Is this possible and if so can you tell me how? THanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to handle multiple currencies with one spreadsheet | Excel Discussion (Misc queries) | |||
Using Excel spreadsheet as input to Access | Excel Discussion (Misc queries) | |||
Spreadsheet merging problems | Excel Worksheet Functions | |||
Linkage data between two spreadsheet | Excel Worksheet Functions | |||
Linking formula to external spreadsheet | Excel Discussion (Misc queries) |