Scarlet_Buckeye
Posts: 5,264
Sep 2, 2013 1:17pm
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?
O-Trap
Posts: 14,994
Sep 2, 2013 2:31pm
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'.
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'.
ernest_t_bass
Posts: 24,984
Sep 2, 2013 3:56pm
ctrl + A, then delete.
said_aouita
Posts: 8,532
Sep 2, 2013 6:14pm
Quite reading after this part.Scarlet_Buckeye;1494494 wrote:Okay... I'm an idiot.
O-Trap
Posts: 14,994
Sep 2, 2013 6:30pm
Quit spelling "quit" with an "e" on the end.said_aouita;1494567 wrote:Quite reading after this part.
W
WebFire
Posts: 14,779
Sep 2, 2013 9:13pm
Correct.ernest_t_bass;1494534 wrote:ctrl + A, then delete.
M
MontyBrunswick
Sep 3, 2013 11:11am
I voted for Cletus