But won’t excel detect there’s no values and no print anything?
I think it has logic to only print pages which have values.
-
Type “.” In A1
-
Change the fill colour of A1 to Black
-
[CTRL] + [A] (Selects all cells)
-
[CTRL] + [R] (Copy’s the left most selected column across to the right most select column)
-
[CTRL] + [D] (Copy’s the top most selected column down to the bottom most select column)
Every cell will now contain the value “.” and be set to fill colour black.
-
Right click any of the column letters at the top > Set width > 1000. (Changes the column width to 1000 pixels. (Expanding the cells so they take up more room when printing)
-
Right click any of the row numbers at the left hand side > Set height > 1000. (Changes the row height to 1000 pixels. (Expanding the cells so they take up more room when printing)
-
[CTRL] + [P] (Opens up the print dialog)
-
[ENTER] (Selects the print button to start printing)
So every HR person and senior management?