Excel help

Home ▸ Archive ▸ Serious Business ▸ Excel help
Scarlet_Buckeye's avatar

Scarlet_Buckeye

Senior Member

5,264 posts
Sep 2, 2013 1:17 PM
Okay... I'm an idiot. I have an Excel file and I'm interested in limiting the "area". Meaning, I ONLY have data in Columns A-H, and Rows 1-275. Therefore, I don't need any Rows or Columns outside of that range. Well, when I perform a Search, I can see it's calculating ALL cells in the sheet. I don't want to "hide" those other columns/rows. I want to completely ELIMINATE them. I did this once before, but I completely forget how. Any help?
Sep 2, 2013 1:17pm
O-Trap's avatar

O-Trap

Chief Shenanigans Officer

14,994 posts
Sep 2, 2013 2:31 PM
Go to column 'I' and click the column header (the 'I' box at the top). Then, hit Ctrl+Shft+Left. Should highlight all columns that have data that you don't want. Then, right click the selected area, and click 'Delete'.

Go to row 276, and click the row header (the '276' box at the far left). Then, hit Ctrl+Shft+Down. Should highlight all rows that have data that you don't want. Then, right click the selected area, and click 'Delete'.
Sep 2, 2013 2:31pm
ernest_t_bass's avatar

ernest_t_bass

12th Son of the Lama

24,984 posts
Sep 2, 2013 3:56 PM
ctrl + A, then delete.
Sep 2, 2013 3:56pm
said_aouita's avatar

said_aouita

Banned

8,532 posts
Sep 2, 2013 6:14 PM
Scarlet_Buckeye;1494494 wrote:Okay... I'm an idiot.
Quite reading after this part.
Sep 2, 2013 6:14pm
O-Trap's avatar

O-Trap

Chief Shenanigans Officer

14,994 posts
Sep 2, 2013 6:30 PM
said_aouita;1494567 wrote:Quite reading after this part.
Quit spelling "quit" with an "e" on the end.
Sep 2, 2013 6:30pm
W

WebFire

Go Bucks!

14,779 posts
Sep 2, 2013 9:13 PM
ernest_t_bass;1494534 wrote:ctrl + A, then delete.
Correct.
Sep 2, 2013 9:13pm
M

MontyBrunswick

Sep 3, 2013 11:11 AM
I voted for Cletus
Sep 3, 2013 11:11am