How to Hide Data in a 2013 Excel Worksheet Quickly and Easily
Some data is necessary for functions and tools, but is distracting on an otherwise clean worksheet. To keep your sheet neat, hide the data using the …
Continue ReadingSome data is necessary for functions and tools, but is distracting on an otherwise clean worksheet. To keep your sheet neat, hide the data using the …
Continue ReadingWindows 8 was built for touch devices. Mice and keyboards worked, but the implementation was so poor that for Microsoft’s next Windows release they …
Continue ReadingA quick way to find and delete blank rows in a worksheet is to use Excel’s filter feature. Learn how to locate and remove entirely blank rows …
Continue ReadingIn changing capitalization, Word gives you the options of Lowercase, Uppercase, Sentence Case, Capitalize Each Word and Toggle Case. Learn how to use …
Continue ReadingSeveral Excel functions and tools require knowing the unique values contained in a dataset. The simplest solution is Excel 2013’s Advanced Sort & …
Continue ReadingDid you know Office 2016 was released in September 2015? Nearly six months after release, there seems to be little fanfare. Is anything new in one of …
Continue ReadingWith the recent release of Office 2016, you may be wondering which version would be appropriate for you to use. Well – you’ve come to the right place. …
Continue ReadingExcel 2013 offers numerous text and cell formatting options, including options to change text orientation. This option conserves horizontal cell space …
Continue ReadingExcel 2013’s Conditional Formatting tool offers, among other things, graphical elements that are directly linked to data within cells. One such visual …
Continue ReadingExcel’s Icon Sets add dynamic, visual elements to aid in data identification within cells. Available graphics include traffic lights, checkmarks, …
Continue ReadingExcel 2013 supports multi-tiered sorting rules to arrange data as you prefer, but the default sorting rules only provide alphabetical or …
Continue ReadingMicrosoft Office’s AutoCorrect feature enables you to add custom entries manually. You can capitalize on the option for customization by …
Continue Reading