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.
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:
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.
Get the sample file on the Advanced Filter Macros page, and see how quick and efficient Advanced Filters are at extracting data.
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
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!
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.
Last updated: October 29, 2021 3:00 PM