Is there any shortcut for selecting all the cells of the worksheet except the first row?
Many times the first row contains the coloumn headings so that's why I would like to know a shortcut to omit that row and select rest of the cells.
Thanks
Is there any shortcut for selecting all the cells of the worksheet except the first row?
Many times the first row contains the coloumn headings so that's why I would like to know a shortcut to omit that row and select rest of the cells.
Thanks
You could try this, select row 2, then press Ctrl+Shift+Down Arrow
oldchippy
-------------
![]()
![]()
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Thanks oldchippy that worked...Originally Posted by oldchippy
Good - thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks