Saturday, 22 January 2022

EXCEL techniques

 FIX TOP ROW AS HEADERS

Freeze panes to lock the first row or column in Excel for Mac
  1. Freeze the top row. On the View tab, click Freeze Top Row. ...
  2. Freeze the first column. If you'd rather freeze the leftmost column instead, on the View tab, click Freeze First Column. ...
  3. Freeze as many rows or columns as you want.

...


https://www.bluepecantraining.com/how-to-make-multiple-selections-in-an-excel-drop-down-list/

https://trumpexcel.com/select-multiple-items-drop-down-list-excel/#VBA-Code-to-allow-Multiple-Selections-in-a-Drop-down-List-without-repetition








No comments:

Post a Comment

All comments are moderated before publishing