Tuesday , 2 June 2020

Tag Archives: excel

Quick Tip: Fill in blank cells in Excel quick and easy

This pointer was initially released in April 2010 however continuouslies be among our most prominent. Among the initial points you ought to do when importing international information right into Excel or after obtaining a tradition workbook is to look for empty cells and also load them in, where ideal. Certainly, some cells are empty purposefully and also needs to stay ... Read More »

Quick Tip: Excel 2013 offers flexible data labels

Excel 2013 offers more formatting and shape options for displaying data labels in a chart. It also supports a dynamic data label option. We’ll explore those options and then put them to use. How to add data labels First, you’ll need some data labels. You can work with most any simple chart. (We’ll work through a simple example with an ... Read More »

October Office tip mailbag: Outlook settings and Excel conditional formatting

This month, I help a reader find a familiar and friendly Word setting. In addition, I show a reader where to find a mail setting after upgrading to Outlook 2010. I also supply a unique conditional formatting rule that combines AND() and OR() – a bit unusual, but doable. An Outlook setting Jerry upgraded to Office 2010 and like most ... Read More »

Pro tip: Add an ordinal indicator to a value in Excel

Adding an ordinal indicator – st, nd, rd, and th – uses a suffix to denote the value’s position within a series. For example, 1 becomes 1st, 2 becomes 2nd, 3 becomes 3rd, and so on. In Excel, you can use a complex formula to create a new string or you can apply several conditional formatting rules to display the ... Read More »

20 Excel tips for creating stylish spreadsheets

By Carlo Pandian Most Excel users would probably agree that the program is a godsend when it comes to creating spreadsheets, yet the results can often be boring to look at. Thankfully, Excel also provides the tools to make your spreadsheets look polished, professional, and pleasing to the eye. Chris Littlewood is Strategy & Research Director at Filtered, an online ... Read More »

Pro tip: Three ways to hide zero values in an Excel sheet

Zeroes are valid data, but for various reasons you won’t always want to display them in an Excel sheet. When this is the case, you have at least three options. Your data and business requirements will dictate the method you choose. Sheet setting Perhaps the simplest way to hide all zero values in a sheet is to let the worksheet ... Read More »

Pro tip: Dismiss Excel’s irksome Auto Fill Options list with these tricks

    Excel can sometimes be annoying when it’s trying to be helpful. Its Auto Fill Options list is a perfect example. The Auto Fill Options list appears when you use the fill handle (Figure A). To see the options, click it (Figure B). In the case of the example below, the default action is to continue the series. (The default ... Read More »