Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Background Viewed Columns
I have a spreadsheet table. want to remove the surrounding rows and columns
that are not a part of this table. How to do? -- Janet A. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Background Viewed Columns
Work with a copy of your workbook in case things don't go the way you expect.
Simply Select the rows to remove (you can do that by selecting the row numbers on the left side of the worksheet) then use Edit -- Delete to physically remove them. Do the same for columns you don't want (select the columns by selecting their column letters at the top of the sheet); then Edit -- Delete also. Hope this helps. "Janet A. Thompson" wrote: I have a spreadsheet table. want to remove the surrounding rows and columns that are not a part of this table. How to do? -- Janet A. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Background Viewed Columns
Hi Janet
You cannot remove; but you can hide... --Select the row beneath the table. To select the row click on the row header or press (Shift + Spacebar) --Using Shift+Ctrl+DownArrow select all rows down --From menu FormatRowHide --Select the column after the last column. To select the column click on the column header or press (Ctrl + Spacebar) --Using Shift+Ctrl+RightArrow select all columns towards right --From menu FormatColumnHide If this post helps click Yes --------------- Jacob Skaria "Janet A. Thompson" wrote: I have a spreadsheet table. want to remove the surrounding rows and columns that are not a part of this table. How to do? -- Janet A. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove background of a picture in Excel & Power Point | Excel Worksheet Functions | |||
Excel background gridlines on worksheet-how do I remove from view | Excel Discussion (Misc queries) | |||
how do i remove viewing the words Page 1 in the background in an . | Excel Discussion (Misc queries) | |||
Remove highlight background in cell | New Users to Excel | |||
change data in rows to be viewed in columns | Excel Discussion (Misc queries) |