-
Continue reading →: EXCEL TRICK – TILTED HEADINGSOne way to make your report or sheet more cool is to use tilted headings. Below we have some example data. Select the columns that you wish to tilt – in this case we select the first row. Right-click and then select “Format Cells” In the window that appear, select…
-
Continue reading →: EXCEL TRICK – CREATE DROP-DOWNCreating drop-down lists in Excel is very useful when you want the user to select a specific item. We are going to use 2 sheets here, on sheet two, create a list of items that you want to appear in the drop-down. In the first sheet, type some text Now…
-
Continue reading →: REMOVE THE GRIDLINESSometimes an presentation can look more professional with all the gridlines removed. This can easily be fixed in Excel. As we can see, this looks more clean.
-
Continue reading →: EXCEL TRICK – FLIP DATAIf you have a sheet arranged like below, adding more and more data into it would become hard to maintain. A better approach would be to arrange the above into columns. Luckily we dont have to do this manually. There is a feature called Transpose that we can use. Follow…
-
Continue reading →: EXCEL TRICK – LOCK ROWWe often have a lot of columns. As we continuously enter data at the bottom, it’s easy to forget which column we are in. There is a feature that we can use to prevent this. It allows us to lock the first row with headers. This way, we always enter…
-
Continue reading →: EXCEL TRICK – SHOW ALL FORMULASIf we have a worksheet with a lot of formulas, it would sometimes be nice to see them. This can be done without clicking all the individual cells. Below we have some random numbers and some formulas in column D. To view all the underlying formulas, go to the “FORMULAS”…
-
Continue reading →: EXCEL TRICK – SELECT ALL CELLSIf we have a column with a moderate number of cells, it is easy to select all the cells. Simply mark a cell and drag the cursor to the bottom. But if we have a column with thousand of cells – this is now very efficient. Above we have a…
-
Continue reading →: EXCEL TRICK – COMBINE CELLSSometimes there is a need to combine the values in multiple cells into one cell. There are many ways to do this. One simple way is to use the & sign. In column A to C we have different fruits, and in column D we have combined them using a…
-
Continue reading →: EXCEL TRICK – AUTOFITIf we have columns with truncated cells, it is difficult to read without adjust every single column. To avoid adjust column by column there is an in-build feature to handle this. Below we have data that we can’t see in both columns. So, select all the data – CTRL+A In…
-
Continue reading →: EXCEL CREATE ASCII TABLESometimes when we create formulas or calculations we need to take into account ASCII-characters. So, in this part we are going to look at how we can print all the ASCII-characters. In column A – enter the digits 0 to 255. These represent all the ASCII-codes. To output a ASCII-character…
Hi,
I’m Henrik
Welcome to Excel tutorials made easy. This site is full of easy to follow tutorials
Join the fun!
Stay updated with our latest tutorials and ideas by joining our newsletter.
Excel tutorials 