• I2jgwh0hYtxrCZQ@lemmy.sdf.org
      link
      fedilink
      arrow-up
      7
      ·
      edit-2
      7 hours ago

      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.

      1. Type “.” In A1

      2. Change the fill colour of A1 to Black

      3. [CTRL] + [A] (Selects all cells)

      4. [CTRL] + [R] (Copy’s the left most selected column across to the right most select column)

      5. [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.

      1. 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)

      2. 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)

      3. [CTRL] + [P] (Opens up the print dialog)

      4. [ENTER] (Selects the print button to start printing)