In MS Excel, a cell can hold different types of data like currency, numbers, dates etc. Users can set the cell type in different ways such as: Right click on cell, Format Cells, then …
MS Excel offers two smart ways to reverse every action in the worksheet using the Undo command. • Go to the Quick access too-bar and click on Undo. • Simply Press Control + Z …
Text boxes in MS Excel acts as special graphic that combines the text in a rectangular graphic object. Text comments remains always visible in the rectangular box. Adding Text Boxes In order to add …
Adding Comment to the Cell Adding comments to the cells is very valuable as it helps in understanding the purpose of the cell. It helps in facilitating a proper documentation. Here are three smart …
Sometimes users require inserting some symbols or special characters in the worksheet that are not available on the keyboard. MS Excel offers offer symbols ad special characters to use in the worksheet. Using Symbols …
Zoom Slider In MS Excel, by default everything on screen is displayed at 100%. Users can change the zoom percentage from 10%, which happens to really tiny to 400 which is huge. Zooming doesn’t …
MS Excel comes with Spelling check feature that can help in getting rid of spelling mistakes. Spell Check basis • To access the spell checker, go the Review and click on Spelling or simply …
Find and Replace Dialogue Go the Home followed by Find & Select and Find or simply press Control + F Key. You can now see the Find and Replace dialogue with more options. Now …
MS Excel allows user to copy paste in various different ways. Copy Paste • First, select the cell you want to copy. Then, choose copy option after giving a right click by simply pressing …
MS Excel spreadsheet is in tabular form that consists of rows and columns. A row happens to run horizontally while column runs vertically. Each row can be identifies by the row number placed at …