Suppose you are working on Excel, and repeatedly you have to perform the same actions. Then you can create a macro for that and use it as many time in the worksheet. A macro record the actions, it can be a mouse click, keystroke, or modification in a font, etc. Creating macro saves time. So let's move towards the steps of How to Create Macros in MS Excel 2016? Steps to Create Macro in MS Excel … [Read more...]
How to Protect Worksheet and Cells in MS Excel 2016?
Sometimes you have to share the Excel sheet with some other users also. Like, you have created an entire years surveillance data of the company and wanted your juniors to mark their remark on it. At the same time, you don't want your data to be hampered or changed in any way. Then, you must protect the cells containing the important data. Sometimes you even want to protect the entire sheet from … [Read more...]
How to Freeze Rows and Columns in MS Excel 2016?
Suppose, you have an Excel sheet that contains a lot of data. To read the data at the bottom of the sheet, if you scroll the sheet upward, the headings that lie in the top row will be invisible. It will make no sense of reading data without headings. Same is the case with column if you scroll the sheet rightwards the columns to the left will be invisible. The best way to retain rows and columns is … [Read more...]
How to Split Text in a Cell in MS Excel 2016?
In case you have entered some information in a single cell in Excel, and you want to split the text into separate columns then MS Exel has provided an easy way to split the text in a cell. So let us begin with How to Split Text in a Cell in MS Excel 2016? Step to Split Text in a Cell in MS Excel 2016: Step 1: First select the cells, whose text you want to split. You can observe in the image … [Read more...]
How to Create a Drop-Down List in MS Excel 2016?
To make your Excel worksheet more efficient, use the drop-down list in the cell. It is easy to select from the list instead of typing in each cell particularly. It also saves time. In this article, I have tried to show you how you can easily make a cell into a drop-down list. So Let us proceed with steps of How to Create a Drop-Down List in MS Excel 2016? Steps to Create a Drop-Down List in MS … [Read more...]
How to use Mail Merge in MS Word 2016?
All organizations communicate with their customers in the form welcoming emails, informing letters and they have to send it in bulk. Preparing a separate letters or emails or envelopes for each individual would make the work tedious. MS Word has provided the Mail Merge facilities to resolve this problem. Here, one can create a batch of letters, emails, envelopes, or labels. It also saves you time … [Read more...]
How to Insert Symbols in MS Word 2016?
While creating a document you may need some symbols or some special character. These symbols or special character may not be present on your keyboard. The symbols or the special characters are specific to the type of font you are using like, the font Webdings include decorative symbols. You can remeber the character code of the symbol and when you need type the character code for the symbol and … [Read more...]
How to Insert Clickable Checkbox in MS Word 2016?
Checkboxes help us to make a checklist which resembles whether we have completed the task or it is still remaining. MS Word allows you to make a checklist with the checkboxes that are clickable. Checkbox once clicked is checked and on second click it gets unchecked. So let us see How to Insert Clickable Checkbox in MS Word 2016? Step to Insert Clickable Checkbox in MS Word 2016: Step 1: Open an … [Read more...]
How to Create Insert and Update Citation in MS Word 2016?
Suppose you have to create a report. You will definitely refer various sources to collect the information regarding the topic of your report. When you create your report, you may put some information that you have referred from some other source. So you need to mention the source there, from where you have referred this stuff. Citation represents the source from where you have referred this … [Read more...]
How to Create Cross-reference in MS Word 2016?
While reading a document, you may come across some text, or word or figure that is better explained in another location of your document. So cross-reference helps you to create a hyperlink that will take you to the another location in your document. In MS Word you are allowed to create a cross-reference only to headings, footnotes, bookmarks, captions, and numbered paragraphs. In case if you … [Read more...]
- « Previous Page
- 1
- …
- 5
- 6
- 7
- 8
- 9
- …
- 13
- Next Page »