Excel Roundup 20150126

Weekly Excel Roundup http://blog.contextures.com/

Here is a short video, by Dennis Taylor from Lynda.com, that shows some keyboard shortcuts for formatting on a worksheet. For example:

Ctrl + Shift + - (hyphen) to remove borders in selected cells Ctrl +5 to change text to Strikethrough

He also shows how to use the ISFORMULA function, new in Excel 2013, with conditional formatting, to dynamically highlight cells that contain formulas. You can get written instructions for that technique on my website.

(adsbygoogle = window.adsbygoogle || []).push({});

Continue reading Excel Roundup 20150126

Excel Roundup 20150119

Weekly Excel Roundup http://blog.contextures.com/

In this tutorial, from the Lynda.com website, you can learn 5 helpful Excel keyboard shortcuts, for tasks such as toggling the Ribbon on and off, and showing a print preview.

I use the mouse, and buttons on the QAT, for most of these commands, but if you're a keyboard person, you might like a couple of these shortcuts. Or did you know all of them already?

Contextures Posts

Here’s what I posted recently:

You can delete worksheet rows based on a specific Conditional Formatting color Give your Excel Pivot Table a makeover so the data is easier to read

Continue reading Excel Roundup 20150119

Delete Rows With Conditional Formatting Color

Delete rows based on Conditional Formatting color http://blog.contextures.com/

If you've highlighted cells with conditional formatting, what's a quick way to delete the rows those cells are in?

Someone asked that question on one of my old blog posts last week. That article showed how to use the Find command, to get a list of cells that contain a specific word. Then, delete the rows for those cells.

It's a handy trick, but won't work to select cells that are colored with conditional formatting.

Continue reading Delete Rows With Conditional Formatting Color

Excel Roundup 20150112

Weekly Excel Roundup http://blog.contextures.com/

Doug Glancy used Excel's camera tool, and some VBA, to create a mesmerizing "selfie" of a range which has conditional formatting applied. Doug describes the results:

Kind of like when you’re in a dressing room with the mirrors front and back and you get a reflection of a reflection of a reflection … Unless you’re like me and you just keep buying the same pants online.

I downloaded the sample file, and changed the colours, to match my Contextures logo. I'm not sure if this has too many practical applications, but perhaps you can use it to hypnotize your boss,

Continue reading Excel Roundup 20150112

Excel Roundup 20150105

Weekly Excel Roundup http://blog.contextures.com/

Happy New Year! I hope you had a relaxing end to 2014, and great start to 2015.

If you're working in Excel at the beginning or end of a year, dates can be a problem. Usually, you can enter the day and month, then press Enter, and Excel will add the year.

Most of the time that works well, but if you're doing December month end reports in January, Excel will add 2015 – the current year. Remember to manually enter the year to the date, if it's not the current year – 12/31/14. And that means typing 3 extra

Continue reading Excel Roundup 20150105

Today is Excel Date 42000

Day 42000 in Excel http://blog.contextures.com/archives/2014/12/27/today-is-excel-date-42000/

This is day 42000 in the Excel calendar, so maybe we'll get the "Answer to The Ultimate Question of Life, the Universe, and Everything" – a thousand times!

Continue reading Today is Excel Date 42000

Excel Roundup 20141215

Weekly Excel Roundup http://blog.contextures.com/

Thank you for reading my Excel Roundup every Monday, and after this week, I will be taking a couple of weeks off, to enjoy the holidays. There will be a blog post here this Thursday, and the next roundup will be posted on January 5th.

To help you celebrate, here is a no-macro animated Christmas tree, created in Excel, of course. Just move the scroll bar, to add lights, tinsel, a star, and presents, to the tree. You could use this technique for less festive projects too, like a business dashboard. Read the details on my Contextures website.

 

Continue reading Excel Roundup 20141215

Excel Roundup 20141208

Christmas is only 2-1/2 weeks away, so it's time to start planning! Of course you'll want to organize everything in a spreadsheet, so you can download the free Excel Holiday Planner, from my Contextures website.

It has shopping lists, budget sheets, task lists, and even a dinner planner, so get your copy, and get the holidays under control.

Continue reading Excel Roundup 20141208

Contextures Cyber Monday Sale 2014

Happy Cyber Monday! I hope you didn't spend all you money at the Black Friday sales, and have a little left over for today's shopping spree.

To celebrate Cyber Monday, the busiest online shopping day of the year in the USA, you can buy a couple of my Excel products, at 50% off today only. The details, and links to the product pages, are below.

NOTE: Unfortunately, the shopping cart will only discount one item per order -- if you want both items, please order them separately.

Continue reading Contextures Cyber Monday Sale 2014

Excel Roundup 20141201

Weekly Excel Roundup http://blog.contextures.com/

Wow! It's December already – how did that happen? It's Cyber Monday too – a big online shopping day. Did you find any Excel bargains?

To start the countdown to Christmas, Mynda Treacy created an Advent Calendar in Excel. You can download the file, if you'd like a bit of fun while you count the days until Christmas

You'll have to answer a quiz each day, to open the calendar doors. To get a head start, you can start thinking about the answer to the December 5th question, shown in the screen shot below.

Continue reading Excel Roundup 20141201