microsoft office excel
, , , ,

How To: Copy "Page Setup" (Margins) to All other Worksheets in Office Excel

When we have a workbook with multiple worksheets & we need to print them neatly and prettily, with the same headers, footers, margins, page orientation and so on. If there is one worksheet, we can setup the page settings for the worksheet…
microsoft office excel word power-point
, , ,

Complete list of Keyboard Shortcuts for Microsoft Office Excel (All Versions)

This article describes keyboard shortcuts, function keys, and some other common shortcut keys for Microsoft Excel for Windows. This includes the access keys that you can use for Ribbon commands. FREQUENTRLY USED SHORTCUTS If you're new to…
microsoft office excel word power-point
, , ,

How To: Remove Automatic Horizontal Line in Office Word

Word automatically formats items like quotes, bulleted and numbered lists, and horizontal lines. When you type at least three dashes, underscores, or equal signs in a paragraph by themselves and press “Enter”, the characters are automatically…
Microsoft Office - kamiltech
, , , ,

Add or Remove Protection in Microsoft Office Word document, Excel worksheet & PowerPoint presentation

In Microsoft Office, you can use passwords to help prevent other people from opening or modifying your documents, workbooks, and presentations. WARNING: It's important to know that if you don't remember your password Microsoft can’t retrieve…
Microsoft Office - kamiltech
, , ,

How To: Use HLOOKUP Function in Office Excel

HLOOKUP function in Excel is a sibling of VLOOKUP function. The H in the HLOOKUP stands for “Horizontal” and hence it is often called as Horizontal Lookup. HLOOKUP is a very useful function for creating horizontal lookups, but as most…
microsoft office excel word power-point
, , ,

What is Page Layout in Microsoft Office Excel

Many of the commands you'll use to prepare your workbook for printing and PDF export can be found on the Page Layout tab. These commands let you control the way your content will appear on a printed page, including the page orientation and margin…
microsoft office excel word power-point
, , ,

Tips for printing spreadsheets in Office Excel

So you've made an Excel workbook full of data. It's well organized, it's up to date, and you've formatted it exactly like you want, so you decide to print out a hard copy … and it looks like a mess. Excel worksheets don't always look great…
Microsoft Office - kamiltech
, , ,

How To; Use VLOOKUP function in Office Excel

As September approaches, I can count on a series of spreadsheet questions. One popular Excel tutorial request is how do you look up a value on one Excel worksheet and use it on another Excel worksheet. For example, you need to translate a product…
microsoft office excel word power-point
, , ,

How To: Create a fillable form in Office Word

Do you know you can create a fillable form in Microsoft Office Word? I heard No. Really? But yes you can create a filable form in Microsoft Office Word and How to do it? Just follow the instruction below. To create a form in Word that…
microsoft office excel word power-point
, , ,

How To: Change the line spacing in Microsoft Office Word

The fastest way to change the amount of space between lines of text or between paragraphs for an entire document is to use the Paragraph Spacing option on the Design tab, which changes both at the same time. Here below are 3 ways to change…