28 Search results

For the term "alexj".
Pop Up Selector Tool Demo 8

Excel Pop Up Selector Tool With Slicer

Slicers make it easy to select from a list of items, but they take up valuable space on your worksheet. To get the benefits of a Slicer, without the real estate cost, AlexJ made...

15 Years of Excel Tips – How Old Are Your Files? http://blog.contextures.com/ 12

15 Years of Excel Tips

The Internet says that 15 years ago this month, I started my Contextures Excel Tips website. And since the Internet is never wrong, it must be true! The dates are a little hazy, because...

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

Excel Roundup 20150831

In this week’s roundup, see the results from the last roundup’s pivot table survey, build a better dashboard, see some new chart types, and much more. We’re almost at the end of our summer...

Excel Worksheet Navigation Tips http://blog.contextures.com/ 6

Excel Worksheet Navigation Tips

It can be a real pain to find a specific sheet, if an Excel file has lots of worksheets. If I’m making a big file for a client, I’ll often colour groups of sheet...

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

Excel Roundup 20150406

This week, see how to add a table of contents in a workbook, customize the right-click menu, pick a random winner, and many more tips. If you read or wrote any other interesting Excel...

Customize Excel Context Menus http://blog.contextures.com/ 4

Customize Excel Context Menus

When you right-click in Excel, a pop-up menu appears, with a list of commands that you can use. The list changes, depending on where you’ve clicked, so it’s called a “Context Menu”. But, even...

excel diagnostic report http://blog.contextures.com/ 0

Excel Report Diagnostic Display

Did you ever print and distribute pivot table reports in Excel, only to discover – too late – that they weren’t showing the correct information? To help save you from wasted time and paper,...

set minimum row height 19

Set Row Height With REPT Function

Thanks to AlexJ for suggesting a great use for the REPT function – setting a minimum row height. He uses this technique to add a bit of spacing in his tables, so they’re easier...