16 Microsoft Excel Shortcuts Everyone Should Know

AndreyPopov/iStock via Getty Images
AndreyPopov/iStock via Getty Images

Filling out spreadsheets has become synonymous with the more tedious aspects of office life, and while you may never be able to completely rid your day of Microsoft Excel, you can spend far less time in it with the help of some keyboard shortcuts.

With these shortcuts, actions like deleting and inserting rows, which normally require multiple scrolls and clicks, can be done in a fraction of a second. And when you're building spreadsheet after spreadsheet every day, all of those seconds can add up. Check out the cheat sheet below for all the essential Excel shortcuts you should be using on Windows.

  • Shift+Space: Select an entire row
  • Ctrl+Space: Select an entire column
  • Alt+Semicolon: Select visible cells
  • Ctrl+Plus: Insert new row or column above or to the left of selected row or column
  • Ctrl+Minus: Delete selected row or column
  • Alt+Plus: Calculate the sum of selected cells
  • Ctrl+N: Open new workbook
  • Ctrl+S: Save current workbook
  • F4: Repeat last action
  • Ctrl+Up/Down Arrow: Move to the first or last cell in a column
  • Ctrl+X: Cut data in selected cell(s)
  • Ctrl+9: Hide selected rows
  • Ctrl+0: Hide selected columns
  • Ctrl+T: Create table
  • Shift+Arrow key: Add one cell to selection
  • Ctrl+Period: Move active cell clockwise

Celebrate the Holidays With the 2020 Harry Potter Funko Pop Advent Calendar

Funko
Funko

Though the main book series and movie franchise are long over, the Wizarding World of Harry Potter remains in the spotlight as one of the most popular properties in pop-culture. The folks at Funko definitely know this, and every year the company releases a new Advent calendar based on the popular series so fans can count down to the holidays with their favorite characters.

SIGN UP TODAY: Get exclusive deals, product news, reviews and more with the Mental Floss Smart Shopping Newsletter!

Right now, you can pre-order the 2020 edition of Funko's popular Harry Potter Advent calendar, and if you do it through Amazon, you'll even get it on sale for 33 percent off, bringing the price down from $60 to just $40.

Funko Pop!/Amazon

Over the course of the holiday season, the Advent calendar allows you to count down the days until Christmas, starting on December 1, by opening one of the tiny, numbered doors on the appropriate day. Each door is filled with a surprise Pocket Pop! figurine—but outside of the trio of Harry, Hermione, and Ron, the company isn't revealing who you'll be getting just yet.

Calendars will start shipping on October 15, but if you want a head start, go to Amazon to pre-order yours at a discount.

This article contains affiliate links to products selected by our editors. Mental Floss may receive a commission for purchases made through these links.

The New Apple Watch SE Is Now Available on Amazon

Apple/Amazon
Apple/Amazon

Apple products are notorious for their high price tags. From AirPods to iPads to MacBooks, it can be difficult to find the perfect piece of tech on sale when you are ready to buy. Luckily, for those who have had their eye on a new Apple Watch, the Apple Watch SE is designed with all the features users want but at a lower starting price of $279— and they're available on Amazon right now.

The SE exists as a more affordable option when compared to Apple's new Series 6 line of watches. This less expensive version has many of the same functions of its pricier brethren, except for certain features like the blood oxygen sensor and electrical heart sensor. To make up for the truncated bells and whistles, the SE comes in at least $120 cheaper than the Series 6, which starts at $400 and goes up to $800. The SE comes with technical improvements on previous models as well, such as the fall detection, a faster processor, a larger screen, water resistance, and more.

Now available in 40mm ($279) and 44mm ($309), both SE models offer a variety of colors to choose from, such as sliver, space gray, and pink. If you want cellular connection, you’ll have to pay a bit more for the 40mm ($329) and the 44mm ($359).

For more, head to Amazon to see the full list of offerings from Apple.

This article contains affiliate links to products selected by our editors. Mental Floss may receive a commission for purchases made through these links.