ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to select and deselect rows in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/33591-how-select-deselect-rows-excel.html)

Gallant

How to select and deselect rows in Excel
 
I have to Question regarding selecting and deselecting rows,columns,... in
Excel.

1-When some row or cells are selected how we can we just deselect one row
or cell or column?We usually do it by keeping the Ctrl key in other office
program.

2-Is there any way that we can use to select raws or columns one in
between?It could be very useful.

Regards

Gallant

Bryan Hessey


You can de-select a Worksheet, but not a Row nor Column.

You need to select the bulk portion of your Rows or Columns with the
select-shift/select than ADD additional Rows or Columns with the
Ctrl/select as required.

Also, do not mix the selection of Rows and Columns, especially when
doing a 'Hide'


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=384159



All times are GMT +1. The time now is 02:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com