Excel Tip- How To Make cell value formatting stick in a Pivot Table
I have seen this a lot with Pivot tables, the frustration of Excel users when they format their data in a Pivot Table, but they hit refresh or they remove and add back data into the calculations area...
Merged cells, they cause havoc with a spreadsheet. The Effects can be far reaching and sometimes not appear at the time of development. If you do use merged cells you will run the risk of the...
Excel Tip: Export And Save Your Entire Excel Workbook As A PDF
Converting an Excel work sheet or work book to a PDF document is a great way of sharing content without allowing other users to amend your work. From Excel 2010 onwards this is really easy to...
Excel Tip: Export More Than 65000 Lines From MS Access to MS Excel
This is a problem that I have asked about many times. From Excel 2007 onwards the capacity of Excel Rows is waaaaay more than previous versions (in fact it is 1,048,576!). So, why is...
A really common task used frequently in Excel is to compare two lists to highlight items that appear in one list but are not in the other. Here is a great way to combine two great Excel features to...
It is really easy to insert line breaks into Excel cells, all you need to do is hit ALT+ENTER where ever you want one. I know that I normally use them to make text easier to read in cells, longer...