Skip to main content

Posts

Showing posts with the label Excel

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 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