Skip to main content

Posts

Showing posts with the label MS Office

How to add “&” in header in excel?

Just try to add & in header in excel. If you find a way tell us. If not, then just type as shown below. Use double && instead of one. For example, if you want “something & somewhere” in header, then type “something && somewhere” in header and one & will be seen there. It is a very simple method to do. But if not known, takes too much time. Hope you find it useful. Comment if you have doubts or suggestions. Like, tweet and + post if you find it useful. follow us to get more.

How to program with visual basic in Excel?

Want to program in visual basic in excel? For that you have to open visual basic in excel. Here is a way. 1.       Open excel 2.       Press Alt+F11. Or go to developer tools → select Visual Basic. 3.       You have opened the visual basic application window. 4.       Type your program in modules. 5.       Save it. 6.       Run a macro. 7.       Type your module name. 8.       Assign the macro to the desired button. 9.       Click on the button and see that your function is running. Hope you find it useful. Comment if you have doubts or suggestions. Like, tweet and + post if you find it useful. follow us to get more.

How to add hyperlink to your PowerPoint presentation?

Want to take your viewers to some other links in between the presentation? Here is a way. Just select the text from where you want to show external links and files in between presentation.  Right click and select hyperlink option. Or goo to insert menu and select hyperlink.  Select the media or file you want to show by clicking the selected text.  Click OK.  You have made a hyperlink to in your presentation.  Click F5.  Click on the text you hyper linked.  You are watching the file you hyper linked.  Hope you find it useful. Comment if you have doubts or suggestions. Like, tweet and + post if you find it useful. follow us to get more.

What are the shortcuts in MS PowerPoint?

Here are some shortcuts which can help you make your presentation a little bit faster. F6         : Move clockwise among panes in Normal view. Shift + F6        : Move counterclockwise among panes in Normal view. CTRL+SHIFT+TAB             : Switch between Slides and Outline tabs in the Outline and Slides pane in Normal view. ALT+SHIFT+LEFT ARROW        : Promote a paragraph. ALT+SHIFT+RIGHT ARROW      : Demote a paragraph. ALT+SHIFT+UP ARROW : Move selected paragraphs up. ALT+SHIFT+DOWN ARROW      : Move selected paragraphs down. ALT+SHIFT+1          : Show heading level 1. ALT+SHIFT+ +         : Expand text below a heading. ALT+SHIFT + -         : Collapse text below a heading. CTRL+SHIFT+C      : Copy formatting only. CTRL+SHIFT+V      : Paste formatting only. CTRL+ALT+V          : Paste special. CTRL+SHIFT+F       : Open the Font dialog box to change the font. CTRL+SHIFT+P       : Open the Font dialog box to change the font size. CTRL+SHIFT+>   

What are the shortcuts in MS Excel?

Here are some of the shortcuts of Excel 2010 to work in better way. Ctrl + pgup           : switches between worksheet tabs, from left to right Ctrl + pgdn           : switches between worksheet tabs, from right to left Ctrl + shift + &  : applies the outline border to the selected cells Ctrl + shift + _   : removes the outline border from the selected cells Ctrl + shift + ~   : applies the general number format Ctrl + shift + $    : applies the currency format with two decimal places Ctrl +shift + %   : applies the percentage format with no decimal places Ctrl +shift + ^    : applies the scientific number format with two decimal places Ctrl +shift + #    : applies the date format with the day, month and year Ctrl +shift + @  : applies the time format with the hour and minute and AM or PM Ctrl +shift + !     : applies the number format with two decimal places, thousand separator, and minus sign for negative value Ctrl +shift + :      : enters the current

Some Shortcuts of MS Word 2010.

Here are some of the short cuts for MS Word 2010. The basic shortcuts are the common one you know about. These are some of advanced commands you would like to explore about. Short cut Function Shift+F3 Changes the case of letters Shift+F5 Move to the last change Shift+F6 Go to the previous pane or frame (after pressing F6) Shift+F7 Choose the thesaurus command Shift+F8 Reduce the size of selection Shift+F9 Switch between a field code and its results Ctrl+Shift+F3 Insert a selection or block Ctrl+Shift+F8 and then press an arrow key Extend a selection or block Ctrl+Shift+F9 Unlink a field Ctrl+Shift+F11 Unlock a field Ctrl+Shift+E Turn change tracking on or off Alt+Shift+K Preview a mail merge Alt+Shift+N merge a document Alt+Shift+M Print the merged document

How to add symbols in word?

Making report? problem in finding symbols? Dont know how to add symbols? Here is the solution. Click the Microsoft Office Button , and then click Word Options. Click Proofing, and then click AutoCorrect Options. Click the Math AutoCorrect tab. Select the Use Math AutoCorrect rules outside of math regions check box.  Type The symbol as shown below. TO GET TYPE … \above \aleph \alpha \Alpha \amalg \angle \approx \asmash \ast \asymp \atop \bar \Bar \begin \below \bet \beta \Beta \bot \bowtie \box \bra \breve \bullet \cap \cbrt \cdot \cdots \check \chi \Chi \circ \close \clubsuit \coint \cong \cup \dalet \dashv \dd \Dd \ddddot \dddot \ddot \ddots \degree \delta \Delta \diamond \diamondsuit \div \dot \doteq \dots \downarrow \Downarrow \dsmash \ee \ell \emptyset \end \epsilon \Epsilon \eqarray \equiv \eta \Eta \exists \forall \funcapply \gamma \Gamma \ge \geq \gets \gg \gimel \hat \hbar \heartsuit \ho