If you prefer written instruction instead, below is the tutorial. Hidden rows and columns can be quite irritating at times. Especially if someone else has hidden these and you forget to unhide it (or even worse, you don’t know how to unhide these). While I can’t do anything about the first issue, I can show …
When it comes to inserting symbols in Excel, things can get a bit complicated. You either need to know the keyboard shortcut, or use the methods that are not very straightforward. And there are a lot of symbols that many people need to insert regularly, such as the degree symbol, cent symbol, delta symbol, etc. …
As soon as you type a formula in Excel and hit enter, it would return the calculated result, and the formula would disappear. That’s how it’s supposed to work. But what if you want to show formulas in the cells and not the calculated values. In this Excel tutorial, I will cover the following topics: …
If you work with Excel day in and day out, Excel Keyboard Shortcuts can help you shorten your workday and save a lot of time. Additionally, it also has the power to enchant your co-workers and boss into thinking you’re an Excel Wizard. When I started my career as an analyst, I was completely in awe …
Gridlines in Excel are those faint gray lines that you see around the cells in the worksheet. These gridlines make it easier to differentiate between the cells and read the data. Now don’t confuse gridlines with borders. Gridlines are visible on the entire worksheet while borders can be applied to the entire worksheet or to a …
Want to insert the degree symbol in Excel? If you don’t know how to do this already, you may scratch your head and look for options. Unfortunately, it’s not as straightforward as you want it to be. There is no key on the keyboard to do this, or any direct option to do this using …
What comes to your mind when you see text with a strikethrough in Excel (something as shown below)? In most cases, it means that the task or activity has been completed and has been checked off. Those who work with Microsoft Word use this extensively, and there is a strikethrough icon right there in the …
In my last article, I wrote about mouse double-click tricks. In this tutorial, I will show you some amazing things you can do in Excel by using a combination of mouse and keyboard. Shift Rows/Columns/Cells Suppose you have three cells, and you want to shift the content of cell A1 to cell A3 (as shown …
In my first job, we had to go through a rigorous 3-week training before we got any real work. One of the trainers was a 40 something guy with awesome Excel skills. I used to call him the Excel Superman. I still remember the first thing that he told us was to avoid the use …
©trumpexcel.com – Free Online Excel Training
