Filling Cells with Color and Pattern in Excel
Besides text formatting, you can also highlight particular cells by changing their background type. In Excel, you can fill cells with color, gradient, and pattern….
Tag: pinterest
How Excel Stores Date and Time
If you want to use date and time efficiently in Excel, you first have to learn how Excel stores these values. At first,…
Inserting a Row With VBA
In the lesson about inserting rows and columns, I presented how you can insert a new row in Excel. Here, I will show you…
Merging Text with Numbers in Excel
When you have data in multiple columns, you may want to merge them so the data will occupy only one column. Example: In…
Convert Number to Date in Excel
Excel treats date and time as numbers which are then formatted into the Date and Time formats. This gives you the opportunity to convert…
Highlight a Cell With a Keyboard Shortcut
If you are looking for a keyboard shortcut to highlight a cell with a color, I have bad news for you, you won’t…
Convert Notepad Data to Excel
To convert text directly from the notepad, first, you have to open a text file, select the data, and then copy it to…
Backstage View
The backstage view is a place where you can perform operations on the file. The backstage view was first introduced in Excel 2010 and is…
Filter Shortcut in Excel
In this lesson, I will show you how you can use keyboard shortcuts to manipulate filters in Excel. Create filters Take a look…
Delta symbol in Excel
The delta symbol means change over time. It’s handy to use this symbol, instead of writing the whole word like “change” or “difference”….