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

Wayfair’s Fourth of July Clearance Sale Takes Up to 60 Percent Off Grills and Outdoor Furniture

Wayfair/Weber
Wayfair/Weber

This Fourth of July, Wayfair is making sure you can turn your backyard into an oasis while keeping your bank account intact with a clearance sale that features savings of up to 60 percent on essentials like chairs, hammocks, games, and grills. Take a look at some of the highlights below.

Outdoor Furniture

Brisbane bench from Wayfair
Brisbane/Wayfair

- Jericho 9-Foot Market Umbrella $92 (Save 15 percent)
- Woodstock Patio Chairs (Set of Two) $310 (Save 54 percent)
- Brisbane Wooden Storage Bench $243 (Save 62 percent)
- Kordell Nine-Piece Rattan Sectional Seating Group with Cushions $1800 (Save 27 percent)
- Nelsonville 12-Piece Multiple Chairs Seating Group $1860 (Save 56 percent)
- Collingswood Three-Piece Seating Group with Cushions $410 (Save 33 percent)

Grills and Accessories

Dyna-Glo electric smoker.
Dyna-Glo/Wayfair

- Spirit® II E-310 Gas Grill $479 (Save 17 percent)
- Portable Three-Burner Propane Gas Grill $104 (Save 20 percent)
- Digital Bluetooth Electric Smoker $224 (Save 25 percent)
- Cuisinart Grilling Tool Set $38 (Save 5 percent)

Outdoor games

American flag cornhole game.
GoSports

- American Flag Cornhole Board $57 (Save 19 percent)
- Giant Four in a Row Game $30 (Save 6 percent)
- Giant Jenga Game $119 (Save 30 percent)

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

No Squawking, Please: A Backyard Bird Library Is the Star of This Livestream

Bird Library, YouTube
Bird Library, YouTube

Many people discovered backyard birding when they were quarantined in their homes at the start of the COVID-19 pandemic. Even if you have a vibrant wildlife population in your area, the Bird Library webcam is worth checking out. As Atlas Obscura reports, the bird feeder at the focus of the livestream resembles a tiny library where feathered guests can misbehave.

Librarian Rebecca Flowers and woodworker Kevin Cwalina were inspired to build the Bird Library in 2015. Located in a backyard in Charlottesville, Virginia, it features a miniature reading chair, bookshelves, and a reception desk. The decorations are even updated to match the seasons; the feeder currently sports a banner that says "Summer Reading." The main differences setting it apart from a real library are the bird seed scattered on the floor and the avian visitors.

The Bird Library attracts a diverse collection of patrons. Sparrows, cardinals, and mourning doves have been recorded perching on the librarian's desk and checking out the reading materials. The occasional squirrel has also been known to stop by.

Live video of the feeder streams on the Bird Library's YouTube page and website 24 hours a day, 7 days a week. You can play the video below to check in on the current guests. If the backyard Bird Library has inspired you to find birds closer to home, here's some gear for beginner naturalists.

[h/t Atlas Obscura]