Contextures

Contextures News 2021-11-02

Excel Move Data Without Macros

November 2, 2021

Review a spreadsheet, move data without macros, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.

Thank you for reading today's news, and you'll get the next newsletter on November 16th.

Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.

Quick Tip: Formatting

Do you you use the Format Painter to copy formatting from one cell to another? I usually use that tool, but sometimes this mouse trick is quicker, if you want to format cells to the right, or below.

In this example, conditional formatting was added to cell C2, to highlight the hotel costs. To copy that formatting down to the rows below:

  • Select the formatted cell (C2)
  • Point to its Fill Handle, at the bottom right corner of the cell
  • Press the RIGHT mouse button
  • Drag down, over all the cells that you want to format
  • Release the mouse button, and click Fill Formatting Only

There are more mouse tricks on my Contextures site, and if you'd rather use the keyboard than the mouse, there's a long list of Excel Keyboard Shortcuts too.

fill formatting only

Advanced Filter Magic

Advanced filters are one of Excel's most under-rated features. They've been around forever, and can magically send data to a different worksheet, without using macros! If you haven't tried that feature yet, there are steps and a video on my Advanced Filters Intro page.

Advanced filters work well with macros too, and I've got a new sample file that you can download. There's a table with sales orders, and you can click a button to send each sales rep's orders to a different sheet.

  • The SHEET macro button leaves the Rep sheets in the original workbook
  • The WORKSHEET macro button creates a new workbook for each sales rep's data

Get the sample file on the Advanced Filter Macros page, and see how quick and efficient Advanced Filters are at extracting data.

buttons for advanced filter macros

Excel Articles

Here are some Excel-related links that you might find useful or interesting.

Spreadsheet Review: The ICAEW has released a new 20-page guide - How to Review a Spreadsheet, and there is a free webinar tomorrow, November 3rd. Take a look at their previous guide too, if you don't have it yet - 20 Principles for Good Spreadsheet Practice (Level - All)

Excel Games: Robert Gascon posted a new version of his Excel Chess Games Viewer, on Microsoft's Excel Tech Community site. Note: The download link is just below the chess board screen shot. (Level - All)

Spreadsheet History: Andrew Moss shows how spreadsheets started, and developed into powerful tools, over the decades. (Level - All)

Also see: Previous Newsletter Issues

Future Excel Expert

This photo of my granddaughter (Miss A) is from 2013, but it showed up in my Facebook (Meta?) memories this week. Miss A loves to work at my spare computer when she visits, usually typing in Word ("the W") or drawing in Microsoft Paint.

On the day of this photo, I looked over, and she had opened Excel for the very first time. From her expression, you can tell that Miss A thinks Excel is awesome, and she'll run her own spreadsheet business one day!

weekly photo

NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2021/20211102ctx.html
I'll also post any article updates or corrections there.

That's it for this week! If you have any comments or questions, send me an email.

Debra Dalgleish
dsd @contextures.com
ctxdebra @gmail.com

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.

contextures newsletter info

 

Last updated: October 29, 2021 3:00 PM