Skip to main content

Posts

Showing posts with the label Excel

Create a Pictograph in MS Excel

A pictograph is a pictorial graph of some values. In other words: A Pictograph is a way of showing data using images. Usually when we create a graph in MS Excel we get a simple bar graph or other charts available in Excel but not a pictograph. In this post I will show you the way to create a pictograph in MS Excel. Step 1] Open Microsoft Excel Step 2] Select the names and values for which you want to create a pictograph as shown in following picture. Step 3]   Click on bar graph in insert section: Step 4] Select 2-D bar graph as shown in the picture. A bar graph will be created. Step 5] Now right click on the bar graph and select Format Data Series. Step 6] Select Fill->Picture or texture fill->File and select a picture to create a pictograph: In my case I have downloaded a picture of green, red and blue balls that I will use one by one. Step 7] Select Stack option: Repeat the procedure for all the value...

What is auto correct option in MS Excel, Word document

The auto correct option is the option from where you can correct the words and store the word for your dictionary. It is possible from the procedure as shown below. 1) Start MS Word. 2) After that type any sentence what you want or type the document you have been given, for example you type "sandstone", after that if you want to make a shortcut of that word, then go to File , option , 3 Then go to Proofing tab, after that go to autocorrect option button, then in the replace and with texts, you can place and replace your own words. 4 Also you can store and save your daily own hand writing words and any small sentance.

Microsoft Excel Shortcut Keys

The followings are Microsoft Excel shortcuts.  Mouse shortcuts: Shortcut Description Double-click (on a cell) Edit the cell contents. Double-click (on a row/column divider) Adjust height/width to auto-fit High-light headers of multiple rows/columns then Double-click on a row/column divider Adjust height/width to auto-fit of all high-lighted rows/columns Triple-click Select the entire contents in the cell Click on row/column divider then drag Adjust height/width of the row/colunn High-light headers of multiple rows/columns then Click on row/column divider then drag Adjust height/width of the rows/colunns Ctrl + Mouse wheel Zooms in and out of document. Hold Shift + Click the cells Select multiple cells Keyboard shortcuts: Shortcut Description F2 Edit the selected cell. F5 Goto a...

Add Watermark to an Excel Document

Unfortunately, the printed watermark feature is not available on any version of Excel (including Excel 2007, 2010). However, there are some workaround methods to add text or images into an Excel document that would result something similar to a watermark. The followings are examples of Excel Documents with text and image "watermark": Step-by-step procedure to add a watermark to an Excel document (applied for Microsoft Word 97-2010): A. TEXT WATERMARK:   The trick is to place a WordArt on the background of the Excel sheet.   Microsoft Excel 97/2000/XP (2002)/2003: Open the Excel document that you want to add watermark to. Select " Insert " from the top menu, then select " Picture " > " WordArt... ". In the " WordArt Gallery " dialog, select a WordArt style that you like then click " OK ". In the " Edit WordArt Text ...