Remove Background Viewed Columns

  • Thread starter Thread starter Janet A. Thompson
  • Start date Start date
J

Janet A. Thompson

I have a spreadsheet table. want to remove the surrounding rows and columns
that are not a part of this table. How to do?
 
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.
 
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 Format>Row>Hide

--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 Format>Column>Hide

If this post helps click Yes
 
Back
Top