All articles

Two ways to use the format painter

Two ways to use the format painter Format Painter quickly copies formatting between cells, ensuring consistency without spending ages redoing each cell. Two ways to use it: First, single-click to copy formatting from one cell, then click another to paste. Second, double-click to extend the copied formatting to multiple non-adjacent cells. For a visual guide,…

Read article
The faster way to use the fill handle

A Faster way to use the fill handle When you’re copying stuff in Excel from one cell to lots of others nearby, you’d usually drag this little box in the corner of the cell. But in big sheets, that means holding your mouse and waiting for it to scroll down. Here’s a faster way: double-click…

Read article
How to Add the current date to a Cell

Add the current date to a Cell Entering the current date manually can be time-consuming, especially if it’s a frequent task. Fortunately, there’s a handy keyboard shortcut involving a semicolon (;) to swiftly input the current date, along with another shortcut for the current time. Open Excel and go to your sheet. Click the cell…

Read article