You want to display today’s date? Or you want to check, if a date written in a cell is today? There is an easy formula: =TODAY()
Author: Henrik Schiffner
Henrik Schiffner is a freelance business consultant and software developer. He lives and works in Hamburg, Germany. Besides being an Excel enthusiast he loves photography and sports.
Data Source of PivotTables: How to See and Change It
You receive an Excel workbook with a Pivot Table and don’t know what data it is referring to? Or you have added a column or row to your data and want to adapt the Pivot Table?
How to Paste Cell Formatting Only in Excel: 2 Easy Methods!
Formatting an Excel table often takes more time than creating its contents. Borders, background colors, fonts and so on must be set to match your workbook and maybe even company guidelines.
How To Quickly Insert Rows And Columns In Excel
Let’s enhance your Excel skill with some handy keyboard shortcuts: How to insert a new row (or column) within 1 second without using the mouse?
How to Save an Excel File Comfortably to PDF
When you save an Excel file to PDF, you usually go to File, Export, Create PDF/XPS and follow the steps. Let’s have a look at how to add a button to the Quick Access Toolbar so that it’s only one click to save PDF, instead of searching through the menus.
How to Unhide All Rows or Columns in Excel at Once
Many people love the “Hide” function for hiding rows or columns, as it is very easy to use:
Sort: How to Sort Data in Excel
There are several ways to sort data: Using filters, Pivot Tables or the built in Sort function. The sort function has the advantage that it’s easy to use and can be modified in detail.
How to Paste Values Without Formulas in Excel
When you copy and paste cells “the normal way” (Ctrl + c –> Ctrl + v), formulas and formatting is pasted as well. But in many cases, you want to “freeze” the values, so that they can’t be changed any more.
Very Hidden: How to Set Sheets to ‘Very Hidden’ in Excel!
There are many worksheets in your workbook, which are old but you are afraid to delete them?
How to Show Column Letters Instead of Numbers in Excel
Showing numbers instead of letters of columns can be useful, for example, when you work with VBA macros or when you have to count columns (e.g. VLOOKUP).