![]() ![]() Alternatively, you can click on the paintbrush in the pop-up format menu that appears when right clicking, then select the cell you want to format. Then click on Format Painter (the little paintbrush) in the upper toolbar on the Home tab. Format Painter: Select the cell whose format you want to copy.Ctrl End: Navigates to the last cell that contains data.In Mac OS, you may need to add the Fn key for this shortcut to work. Shift F11: Creates a new worksheet in your current workbook called “Macro1.” This shortcut is also known as the insert tab shortcut. ![]() ![]() This only selects cells above and below that have data, so it won’t select empty cells.
0 Comments
Leave a Reply. |