Category Archives: Excel Tips

How to Restore Missing Sheet Tabs (Excel 2013)

Of all the things that can go missing in an Excel sheet (like the missing scroll bars), here’s another one I discovered – missing sheet tabs! This is not the same as hidden sheet tabs.

Error in Inserting Column (and How to Solve It) (Excel 2013)

Let me just start off by saying, thank you very much to those of you who have been patiently waiting for my next post that seems to come once every dinosaur years. So here’s an irritating problem I recently have with Excel and the solution to it…

How to Restore Scroll Bars (Excel 2013)

I’ve never hidden scroll bars by accident or on purpose, especially in Excel files because there are just way too many columns and rows that I have to deal with. One fine busy day, I received a file from one of my colleagues, a file that I have previously sent to him for editing and I am 200% sure I did not hide or disable the scrolling. Guess what? Yep, the scroll bars in that file went Houdini on me:

Delete A Specific Word with Find and Replace Function (Excel 2013)

In the previous tutorial, we’ve learnt how to add a word with the Find and Replace function. Now we’re gonna do the exact opposite – delete! Using the same example, I want to get rid of the word “Expresso”.

Add A New Word In Between Two Words with Find and Replace Function (Excel 2013)

Geez, it’s like I’m on a PMS streak with using the Find and Replace function! I’ve again stumbled upon another trick when I want to ADD a new word in between two words that occur in multiple cells and rows!

Remove Leading Space from Multiple Rows (Excel 2013)

My latest adventure in work got me splitting some data into rows and then scratching my head (unnecessarily) for a situation I didn’t expect after the split… There are over 40 country codes living happily together in one cell but I have to be Cruella de Vil and split them up into lonely individual row. Unfortunately, the split comes with excess baggage – a leading space.

The Trick to Inserting an Image in a Specific Cell without the Need for Macro (Excel 2013)

Inserting an image into an Excel file is very easy and straightforward as you would do so in any Word or PowerPoint file. The challenging bit is…to insert an image in a specific cell. This also means that you intend to ‘lock’ an image in a particular cell so that the image will stay put in that cell only. You don’t really need macro to help you with this. You just need a little trick to do the job!

6 Types of Hyperlink You Can Create in Excel (Excel 2013)

Creating hyperlinks in Excel can be beneficial in terms of helping you to navigate better, i.e. jumping from one worksheet or cell to another, or opening an external file that is linked to a particular worksheet. Here are six types of hyperlink that you can easily create in Excel:

Create Table of Contents in Excel File (Excel 2013)

There are times where your spreadsheet will expand and have several worksheets within the same spreadsheet file. Normally, you would click the worksheet tabs (or next / previous arrow buttons) to navigate between worksheets. That’s okay, but…if you have more than 15 of them, it will be rather troublesome to sort through the list of tabs in your file just to find that particular worksheet!

Merge Multiple Cells at Once (Vertically / Horizontally) with Format Painter (Excel 2013)

Merging multiple cells across rows and columns is a fairly straightforward task. Simply choose the number of cells that you wish to merge, then click the Merge Cells button. Easy peasy, no? What if, you want to merge a defined set of cells in a repeated manner vertically (i.e. across several rows) and / or horizontally (i.e. across several columns)?