Here’s a nice Excel shortcut. Say you want to leave data in a cell but wish to make it invisible. You can do this by going to the Format Cells menu (keyboard shortcut: Ctrl + 1), selecting Custom, and typing three semicolons into the line under “Type.”
Note: if the GIF below is not streaming, try clicking on it to play.
Leave a Reply