Office Guide

We offer office guides and easy step by step tutorials with images and videos that help you to do easy your work.

How to Lock and Hide the Formula in Excel Worksheet

During working on excel sheet, sometime you don’t want to show applied formulas and also lock the active worksheet. In this tutorial, will discuss how to lock and hide the formula in Excel worksheet so that applied formula don’t show in the formula bar. This tutorial very useful for all those excel users who want to know about quickly lock and hide the formulas in active worksheet. Read More

How to enable and disable Sticky keys?

Sticky is an important feature of Windows and Mac Operating System. Sticky key is an accessibility feature which allow his users to press and release any modifier keys (Ctrl, Shift, Alt or Windows) to remain active until l any other key is pressed or released. Read More

How to Add and Use Camera in Excel Quick Access Toolbar

Have you ever take a screen shot of selected data range in a worksheet? If “No”, then try this… it’s a great tool which allows you to take a picture of currently selected range of cells which update dynamically when original data changed at target location. To do this job you have to add and use camera in Excel Quick Access Toolbar. Read More

How to Show Report Filter Pages Excel Pivot Table Data

Pivot table is an important feature of Excel, which allows you to manage and summarize your large worksheet data. In this article, we will discuss how to show report filter pages Excel pivot table data. You can use, Pivot table which is an important and useful tool used for data analysis purpose in Excel. Read More

How to add suffix in range of cells in MS Excel

Do you ever have those situations where you need to add suffix in range of cells in MS Excel. During typing any numeric value can you make an amendment or add suffix text in every selected range of cell. In this guide we have to discuss how could you easily adding suffix in range of cells in Microsoft Excel. Read More

Autosave Excel file using code to protect file

Lot of time many peoples facing these issue like computer crashes, power goes out, accidentally close any file without saving and many more. In that situation you may lost of your working data, and you need to know how to autosave Excel file. There are lot of ways to auto save Excel file either using Autosave feature or using the code. Read More