Excel help?

Question

Hi
I have created a table on Excel. I need to hide or remove the rows and columns beyond the table. The table is from A1 to G24 – leaving these visible how do I remove the other columns and rows?
Thanks for the help.

Answer 1

Select the rows and/or columns you want to hide, then right-click on the row numbers / column numbers and select "hide". There will always be columns & rows visible, however.

Answer 2

If you don't want them to show up in your printout then just select that section and under File set it as your print area.

There is no way to hide these in the view that comes up on your screen. Though you can select that section and in menu under View select Zoom and in the pop up window click Selection and that will only display that section onscreen.

Answer 3

Unused cells are automatically unprinted. However to make yoru table stand out go to:

Format-> Cell-> Border-> Click all of the buttons outlineing which side of the cell you want to be black and click ok.

it will make the gray border turn black.

Answer 4

try to select all other columns or rows and delet or hide them.

Answer 5

I suppose you want a blank area instad of the cells..simply select all the rest (you can do it in steps) right click, and check the "Merge cells" option..you can also pick a colour for it.