Change Display Style of Unread Mail - Microsoft Outlook

Hi,

It has been a long time since we posted any Microsoft Office article. Here we go with Microsoft Outlook. Our task today is To Change the display style of Unread Mail. By default, Microsoft Outlook shows unread message in bold Text or with different color based on Outlook Version.

I am using Microsoft Outlook 2013 (MS-Office version 15.0.xx) in this tutorial. Below is our Expected Result. Above is the default view in Microsoft Outlook 2013 and below is the modified view for Unread Messages. We can follow the same steps to customize formatting styles for different conditions.

Procedure

Step -1 : Click on View Pane, Choose View Settings from Current View section. You can do this directly clicking in Column Headers.

Step -2 : You will get following screen. Choose Conditional Formatting. This is Conditional Formatting window where we change default Rule for selected view. We have selected Unread Message in above case. Then Click on Fonts Button to proceed next. You can also Add new Rule to rule list.

Step -3 : Now change the Font Name, Color, Style, Effect, Size etc from Font Wizard screen. Have a look at below screen.

Ok, you have made the required changes, Restart Microsoft Office Outlook to reflect changes. Your new unread mails will be displayed with new formatting.

Thanks for reading. Hope you find our post helpful. Please share among your friends and social network to help us growing. Feedback and suggestions are always welcome.
+John Bhatt 

Read More

HTTP Error 500.23 - Internal Server Error - Solution 2

Hi,

If you keep visiting here, some days ago, I have posted a same post here. The problem is similar again but difference is another way to solve the same problem.
Lets have a look at fresh snapshot.

HTTP Error 500.23 - Internal Server Error

An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.

Most likely causes:

• This application defines configuration in the system.web/httpHandlers section.

Things you can try:

• Migrate the configuration to the system.webServer/handlers section. You can do so manually or by using AppCmd from the command line - for example, %SystemRoot%\system32\inetsrv\appcmd migrate config "Default Web Site/". Using appcmd to migrate your application will enable it to work in Integrated mode, and continue to work in Classic mode and on previous versions of IIS.
• If you are certain that it is OK to ignore this error, it can be disabled by setting system.webServer/validation@validateIntegratedModeConfiguration to false.
• Alternatively, switch the application to a Classic mode application pool - for example, appcmd set app "Default Web Site/" /applicationPool:"Classic .NET AppPool". Only do this if you are unable to migrate your application.

(Set "Default Web Site" and "Classic .NET AppPool" to your application path and application pool name)

If you are still confused about the previous post, here is the link.
http://www.pyarb.com/2014/02/http-error-50023-internal-server-error.html

Problem

Last time, we received the similar problem while debugging from Visual Studio, this time it is produced by IIS itself after publishing.

Solution

We will add small piece of code into web.config file. This can be done using two methods. Either you open any text-editor (notepad) with Administrator Privilege and open web.config from your IIS root or change the setting in Visual Studio web.config and publish again. What you want to is totally on you.
Piece of Code:

......
<system.webServer>
        <validation validateIntegratedModeConfiguration="false"/>
    </system.webServer>
</configuration>

Place this code inside configuration node. Also, this will not harm you in case of security, This will just tell not to check such settings which are not required.
Thanks for reading. Do not forget to share or provide feedback.
+John Bhatt

Read More

CSS - Cascaded Style Sheet : Part 2 (Selectors)

Hi,

In my previous article, I have written about Introduction of CSS and its basics. In continuation of CSS Tutorial series, this post will help you learning about SELECTOR. We will discuss here for beginners so that they can get maximum and understand the basic difference of their types.

Introduction:

In a embedded or External style sheet, the target element is not fix. Basically we write CSS in embedded or External mode so that we can re-use it when required and can modify whole look of page or website by modifying CSS file only. For using multiple CSS values and properties, we need Identifiers which are called Selector in CSS. Just as In case of C we write a function and use it anywhere, the SELECTOR are same. You will understand more by its example. As per CSS Rule, Selector are divided in three types.

HTML Selector:

HTML Selector are part of HTML Tags. They need not to be used at HTML/XHTML syntax. In short we can define style sheet for any of the markup tags which is used in document but we can not create our own selector of this kind. 

Example:

/* HTML Selectors */
 h1
 {
  font-family: Verdana, Calibry, Tahoma;
  color:green; /* You are strictly suggested to use Hexa color code. Ex. #ff0000 etc. */
  font-size:21px;
  text-decoration: bold;
 }
 
 h2
 {
  font-family: Verdana, Calibry, Tahoma;
  color:blue; /* You are strictly suggested to use Hexa color code. Ex. #ff0000 etc. */
  font-size:18px;
  text-decoration: underline;
  text-align:center;
 }
 
 p
 {
 font-family: Verdana, Calibry, Tahoma;
 text-align:justify;
 padding: 4px 4px 4px 4px;
 }

Class Selector:

Class selector are selectors which need to be used  with class tag in HTML or similar tag in various language. These start with period/dot (.) symbol. These can be used unlimited times in documents and need to be defined each time for markup syntax. You are free to choose name of selector.

Example:

 /*  Class Selectors */
 .textBox
 {
    -webkit-border-radius: 4px;
    -moz-border-radius: 4px;
    border-radius: 4px;
    padding-right: 10px;
    padding-left: 6px;
    padding-top: 2px;
    padding-bottom: 2px;
    font-family: Calibri,Tahoma,Verdana,'Segoe UI';
    border: solid 1px black;
    font-size: 13px;
    text-decoration: none;
    margin-left: 0px;
 }
 
 .button
 {
    font-family: Calibri,Tahoma,'Segoe UI',Verdana, Geneva, 'DejaVu Sans', sans-serif;
    border-top: 1px solid #dec227;
    background: #ffd800;
    background: -webkit-gradient(linear, left top, left bottom, from(#3e779d), to(#65a9d7));
    background: -webkit-linear-gradient(top, #ffd800, #65a9d7);
    background: -moz-linear-gradient(top, #ffd800, #65a9d7);
    background: -ms-linear-gradient(top, #ffd800, #65a9d7);
    background: #ffd800;
    padding: 1px 4px;
    -webkit-border-radius: 4px;
    -moz-border-radius: 4px;
    border-radius: 4px;
    text-shadow: rgba(0,0,0,.4) 0 1px 0;
    -webkit-text-shadow: rgba(0,0,0,.4) 0 1px 0;
    color: white;
    font-size: 13px;    
    text-decoration: none;
    vertical-align: middle;
    height: 27px;
 }

ID Selector:

ID Selector are based upon ID of element. These are initialized with Pound or Hash (#) sign. These can be used only once in a document as the ID of attribute must be unique as per document markup standard. These need not be assigned with attribute but remember, the ID of document element should be same as ID defined in selector. They typography case (lowercase/uppercase) is sensitive here.

Example:

 /* ID Selectors  */
 
 #footer {
    font-family: Calibri,Tahoma,Verdana,'Segoe UI';
    font-size: 15px;
    color: red;
    background-color: #ffd800;
	text-align:center;
}

For you, here is the complete code of HTML Page which is as shown in above screenshot.

<html>
<head>
<title>CSS Stylesheets & Selectors </title>
<style>
/* HTML Selectors */
 h1
 {
  font-family: Verdana, Calibry, Tahoma;
  color:green; /* You are strictly suggested to use Hexa color code. Ex. #ff0000 etc. */
  font-size:21px;
  text-decoration: bold;
 }
 
 h2
 {
  font-family: Verdana, Calibry, Tahoma;
  color:blue; /* You are strictly suggested to use Hexa color code. Ex. #ff0000 etc. */
  font-size:18px;
  text-decoration: underline;
  text-align:center;
 }
 
 p
 {
 font-family: Verdana, Calibry, Tahoma;
 text-align:justify;
 padding: 4px 4px 4px 4px;
 }
 
 
 /*  Class Selectors */
 .textBox
 {
    -webkit-border-radius: 4px;
    -moz-border-radius: 4px;
    border-radius: 4px;
    padding-right: 10px;
    padding-left: 6px;
    padding-top: 2px;
    padding-bottom: 2px;
    font-family: Calibri,Tahoma,Verdana,'Segoe UI';
    border: solid 1px black;
    font-size: 13px;
    text-decoration: none;
    margin-left: 0px;
 }
 
 .button
 {
    font-family: Calibri,Tahoma,'Segoe UI',Verdana, Geneva, 'DejaVu Sans', sans-serif;
    border-top: 1px solid #dec227;
    background: #ffd800;
    background: -webkit-gradient(linear, left top, left bottom, from(#3e779d), to(#65a9d7));
    background: -webkit-linear-gradient(top, #ffd800, #65a9d7);
    background: -moz-linear-gradient(top, #ffd800, #65a9d7);
    background: -ms-linear-gradient(top, #ffd800, #65a9d7);
    background: #ffd800;
    padding: 1px 4px;
    -webkit-border-radius: 4px;
    -moz-border-radius: 4px;
    border-radius: 4px;
    text-shadow: rgba(0,0,0,.4) 0 1px 0;
    -webkit-text-shadow: rgba(0,0,0,.4) 0 1px 0;
    color: white;
    font-size: 13px;    
    text-decoration: none;
    vertical-align: middle;
    height: 27px;
 }
 
 /* ID Selectors  */
 
 #footer {
    font-family: Calibri,Tahoma,Verdana,'Segoe UI';
    font-size: 15px;
    color: red;
    background-color: #ffd800;
	text-align:center;
}
</style>
</head>
<body>
<H1>Types of Selectors in CSS</H1>
<p>In this topic we will be discussing about different types of Selectors in CSS (Cascaded Style Sheets). You will learn about all kind of selectors with examples at the last of this post.</p>
<h2>1. HTML Selector</h2>
<p>As on this line, we did not applied any of stylesheet tags (class or ID). But you will see the changes in style of H1 , H2 and P tag. These are HTML Tags and automatically used by HTTP Web server as they are present in stylesheet.<p>
<h2>2. Class Selectors</h2>
<input type="text" class="textBox" name="FirstName" value="Enter your first Name." />
<input type="button" class="button" name="Submit" value="Click to Submit" />
<p>In above two lines we used class="textbox" and class="button". As in above stylesheet we have created them with period (.) and used with class attribute of HTML element, so these are called Class selectors.</p>
<h2>3. ID Selector</h2>
<p>We will be applying these settings in last of this webpage where we will write footer.</p>
<div id="footer">All Rights are reserved.</div>
</body>
</html>

Thanks for reading. I will be back with another article in CSS series. Your suggestions or feedback are expected and play great role in our development. Keep reading, writing & sharing.
John Bhatt

Read More

CSS - Cascaded Style Sheets : Part 1

Hi,

This time, as we did in beginning for HTML, I am back with CSS Tutorial. This post will contain all information about Cascaded Style Sheets, commonly known as CSS.

Introduction:

CSS is used to decorate HTML elements. This is developed by W3C, Bert Bos, Hakon Wium Lie. In other words it is a scripting language written in any text editor that is used to describe look and formatting of hypertext document. However this is present in all kinds of documents that are written in any markup languages including HTML. Latest version is CSS 4 which is in early stage in current days. CSS Statement is divided in 3 parts in simple.
This is written between STYLE tags or with STYLE attribute if any HTML Keyword. Style tag is container/closed tag of HTML.

Example

text-align : left ;

Property: These are fixed set of keywords which define property of element. In above example text-align is property.
Separator: This separates property and value and always presented by : (colon).
Value: This is the value to property. In above case left is the value of property text-align.

Using Method:

Based on using method, CSS is classified in two parts. One is Internal and other External.

1. Internal: In this method, we write all CSS markup inside the same file where it is applied. This is also done in two methods. 
• Inline CSS: In this method, CSS is written inside the HTML or XHTML statement using STYLE tag. 
• Block CSS: In this method, we write CSS code in HEAD section of HTML document between STYLE tag.
2. External: In this method, we write all CSS markup in another file and insert reference to the file in required HTML file using LINK tag.
   Example:

    <link href="path/to/file.css" rel="stylesheet">

Apart from this, we have another term in CSS which is called SELECTOR.
Selector are simply collection of CSS attributes and their value. Selectors are used in HTML using CLASS or ID or with HTML tag. So further CSS Selector are divided in 3 parts.
We will discuss about all kind of CSS Selector in another post. Before this let me show you an example of CSS used in all methods.

<html>
<head>
<title>Introduction to CSS</title>
<style type="text/css">
h1
{
    font-family: Calibri,Tahoma,Verdana, Geneva, 'DejaVu Sans', sans-serif;
    font-size: 16px;
    font-weight: bold;
    text-decoration: none;
}
</style>

<link href="styles/main.css" rel="stylesheet" />

</head>
<body>
<h1>Introduction to CSS</h1>
<p style="text-align: justify;">This is random text in paragraph.Video provides a powerful way to help you prove your point. When you click Online Video, you can paste in the embed code for the video you want to add. You can also type a keyword to search online for the video that best fits your document. To make your document look professionally produced, Word provides header, footer, cover page, and text box designs that complement each other. For example, you can add a matching cover page, header, and sidebar. Click Insert and then choose the elements you want from the different galleries. Themes and styles also help keep your document coordinated. When you click Design and choose a new Theme, the pictures, charts, and SmartArt graphics change to match your new theme. When you apply styles, your headings change to match the new theme. Save time in Word with new buttons that show up where you need them. To change the way a picture fits in your document, click it and a button for layout options appears next to it. When you work on a table, click where you want to add a row or a column, and then click the plus sign. Reading is easier, too, in the new Reading view. You can collapse parts of the document and focus on the text you want. If you need to stop reading before you reach the end, Word remembers where you left off - even on another device.</p>
</body>
</html>

Keep reading for next part.
John Bhatt

Read More

Problem Opening Office Documents

Hi,
Today I want to tell you about a common problem that you must have faced if you are still using MS Office 2003. When you tried to open the document created by Ms Office 2007, 2010 or 2013 by default this is in different extension and shows error while opening in lower version. To escape from this problem you either have to uninstall your MS Office package and upgrade to higher version (at least MS office 2007) or Ask the author of file to send a compatible file in Office 1997-2003 version.

But here is a best way that you can try without any cost and without any request.To open all types of Office Documents that are of created with higher versions of MS Office, you can download Office Converter. Microsoft has published it as Compatibility Pack for 2007 Office System.

You may follow the link to downnload Microsoft Office Document Converter.
Steps:

• Save Downloaded file to disk.
• When download completes, run the executable file.
• Proceed to installation.
• When complete, reboot your system.

This will install all rendering engine in your Office 2003 and you can open your existing files as well as files with newer version.

+John Bhatt

Read More

Running DOS or C/C++ in Full Screen in Windows 7 or 8

Hi,

If you are a developer, of learning programming languages, you must have to deal with Turbo C/C++ compiler. On the early days of Learning, we have used Windows XP which have ability to run Command Prompt (MS DOS) in full screen mode. But Microsoft has ended support to Windows XP and released 4 new operating system after Windows XP. The major change in newer versions is that, they do not support MS DOS in full screen mode.

Now the requirement is, if you have to work on C/C++ application, you have to work in minimized screen. To make it full screen, we have an application named DOSBox, which is open-source and cross platform.
Below is step by step guide to install and configure DOSBox.

• Download and Install DOSBox from http://www.dosbox.com/download.php?main=1.
• After installing open DOSBox from menu.
  
• You will see following screen.
  
• Type following command to load Turbo C compiler in DOSBox.
  

  MOUNT C C:\TC ⏎
  C: ⏎
  CD BIN ⏎
  TC ⏎
  

  
  
  

Description of Code:

Line 1: MOUNT C C:\TC : Mounts C:\TC (where Turbo C is located) as C Drive. You can choose any drive that exists in your system. This will not effect your existing files.
Line 2: C: : Navigated to C Drive.
Line 3: CD BIN Navigated to Folder BIN normally as we do in MS - DOS.
Line 4: TC Run the Turbo C/C++ Compiler IDE located inside BIN folder.

Lets make it full screen.

Do not forget to change the Directory options from Options menu so that Include directories work fine.
If you find this article helpful, do share with your friends. If you have any suggestions or comments, let us know. We will read and improve ourselves.
John Bhatt

Read More

Microsoft Excel : Text Functions Part -3

Hi,

In previous post we have talked about some of the Text functions in detail. We will continue this post from where we left.

If you have not read previous posts, this post might be some confusing to you. I will request you to read these posts before proceeding.

Text Functions in Microsoft Excel Part -1

Text Functions in Microsoft Excel Part –2

Directly moving ahead to function details and their use.

9. FIXED()

Introduction: FIXED function Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text.
Using Method: This function takes minimum of one and maximum of 3 parameters. First one is Number, this can be any number value or reference to a cell. Second is the decimals , for rounding. Last one is a Boolean option for keeping period separator or not.

=FIXED(139493.4532,2) or =FIXED(A1,-1,TRUE)

Example:

NOTE: Difference between ROUND function and FIXED function is, FIXED converts number to text after rounding but ROUND keep number to number after rounding.

10. LEFT()

Introduction: LEFT function returns specified number of characters from start based in start number (length) in a string.

Using Method: This function takes two parameters. First one is text to be searched, this can be simple string value or reference to a cell. Second is the number of characters to start.
=LEFT("Hello World",6) or =LEFT(A1,6)

Example:

11. LEN()

Introduction: LEN function returns number of characters in a string. In simple words, it returns the length of a string.

Using Method: This function takes single parameter and that is of type string or reference to a cell.

=LEN(“Hello World”) or =LEN(A1)

Example:

 

12. LOWER()

Introduction: LOWER function converts all characters in a string to lower case.
Using Method: This function takes a single parameter and that is of type string or reference to a cell.

=LOWER(“Hello World”) or =LOWER(A1)

Example:

 

13. MID()

Introduction: MID function returns the middle characters from a string specified by start number and length.
Using Method: This function takes three parameters. One is text which is required, another is Start number to search from and another is number of character to show or length to be picked.
=MID(“John is from Nepal”,9,10) or =MID(A1,9,10)

Example:

 

14. PROPER()

Introduction: PROPER function converts all characters and words to Title case as per English Grammar. Means all the beginning character of all words are in capital letter and other are in small letter regardless of their typography.
Using Method: This function takes a single parameter and that is text string or reference to cell .

=PROPER(“this is going to BE CHANGED in title”) or =PROPER(A1)

Example:

 

15. REPLACE()

Introduction: REPLACE function replaces a part of string with specified string.
Using Method: This function takes four parameters, First one is text to be replaced, then starting number of character where replace to be started, then number of character to replace (length), and final one is new text.
=REPLACE(A1,6,3,”was ”) or =REPLACE(A1,6,3,C1)

Example:

 

16. RIGHT()

Introduction: RIGHT function does the exactly same work as LEFT do but from opposite index. This returns the text from end of an string based on the length passed by user.
Using Method: This function takes two parameters and both are required. First one is string or reference to cell containing text and another is number of character to be shown.
=RIGHT(“The last five words”,5) or =RIGHT(A1,5)

Example:

  

I will be back with remaining text function in another post. Thanks for reading.

You can provide feedback using comments or contact page.

John Bhatt

Read More

Text Function : Microsoft Excel Part-2

Hi,

Lets come back to Excel series. We have previously talked about text functions in Excel. Before proceeding to detailed description and use of these functions, I would recommend you all to read previous part of this post at Text Functions in Microsoft Excel - Part 1.

1. BAHTTEXT()

Introduction: BAHT is the currency name of Thailand. This function simply convert the number to BAHT text and adds a sign also. But in Thai Text. In simple word, this function converts number to currency in Thai language.

Using Method: This function simply takes a single parameter. A number and writes BAHT amount in words.

=BAHTTEXT(1000) or =BAHTTEXT(A1)

Example: 

2. CHAR()

Introduction: CHAR function is derived from word character. As simply name suggests, this function returns the character of your input number based in your computer setting. This takes value from 0-255 and returns all the character set based in your value.

Using Method: This function takes single parameter and that is integer from 0-255.

=CHAR(48)

Example: Suppose ASCII value for 0 (number zero) is 48.

3. CLEAN()

Introduction: CLEAN function simply removes the non-printable character from your supplied string. 

Using Method: This function takes single parameter and that is of any kind of value in cell.

=CLEAN(A1) or =CLEAN(CHAR(17)&"This is actual Printable Text."&CHAR(17))

Example:

4. CODE()

Introduction: CODE function works just opposite to CHAR function. This returns the character code of your system as input character. 

Using Method: This function takes single paramater and of type Character as input. 

=CODE("A") or =CODE(A1)

Example:

5. CONCATENATE()

Introduction: CONCATENATE function joins multiple text string into one single String. This works with multiple cells.

Using Method: This function can take multiple inputs of different types separated by comma (,).
=CONCATENATE(A1,A2,A3)

Example:

6. DOLLAR()

Introduction: DOLLAR function converts your number to currency format as per your system locale setting. If you are using United States as your location, then this function will put a dollar sign and comma separator. If you are in India, this will put a Rupees sign as per your system and write as currency.
Using Method: This function takes two parameter, one is value and other is decimal. Then this will convert your number to currency text with decimals as your choice.
=DOLLAR(100,2) or =DOLLAR(A1,2)
Example:

7. EXACT()

Introduction: EXACT function compares two strings and returns Boolean value, True or False. This is case sensitive. If two strings are exactly same, this function returns TRUE and if any of character is different, then FALSE.
Using Method: This function takes two parameters and both in String format from different cells.
=EXACT(A1,B1) or =EXACT("Google","GOOGLE")
Example:

8. FIND()

Introduction: FIND function returns the position of search string in another string. This is case sensitive. 

Using Method: This function takes minimum of two and maximum of 3 parameters. First one is Find text, this can be simple string value or reference to a cell. Second is the Within text, string where to be searched. Last one is Start number, starting position from where to search. This is optional field.

=FIND("Help",A1) or =FIND(A1,B1,2) 

Example: 

Keep reading. I will be writing about remaining function on later posts. Till then keep sharing your knowledge and feedback.

+John Bhatt 

Read More

Text Functions : Microsoft Excel Part-1

Hi,

After some gap, I am back with Excel Tutorials . Lets learn Microsoft Excel in depth and work with functions. In this post, I am going to discuss all of the text functions with examples.

Function

Some of the best and one line definitions of Function are as below.

• A function is a block of code that performs a calculation and returns a value.
• We define a function as a special type of binary relation.

In short, function is a piece of code that is programmed to perform specific task. There are also some functions in Microsoft excel which can be easily implemented to get better and correct output in timely manner. The most useful and important feature of Microsoft Excel function is, they update their value automatically if any of the parameter (cell value) changed. We need not to change or update the cell which contain formula. Even we can protect the cell which contain formula so that, no one can alter the formula in shared document. Functions in Excel are divided in many category according to their use and working nature. Some of them are Text, Date & Time, Logical, Maths & Trigonometry, Engineering etc.

Text Functions

We will be talking about text functions in this post.
Why we call these functions text function?

Clear, they work with text, they can manipulate text cells, they can process normal text. 

The complete list of all text functions is as below. The new functions are added as part of user requirement and improvement in newer version of Microsoft Office.This list is taken from Microsoft Office 2003, so all later versions of Microsoft Excel (2007, 2010, 2013) will work and procedure will be same for all.

1. BAHTTEXT()
2. CHAR()
3. CLEAN()
4. CODE()
5. CONCATENATE()
6. DOLLAR()
7. EXACT()
8. FIND()
9. FIXED()
10. LEFT()
11. LEN()
12. LOWER()
13. MID()
14. PROPER()
15. REPLACE()
16. RIGHT()
17. SEARCH()
18. SUBSTITUTE()
19. T()
20. TEXT()
21. TRIM()
22. UPPER()
23. VALUE()
    Functions added in Microsoft Office 2013.
24. NUMBERVALUE()
25. UNICHAR()
26. UNICODE()

I will be discussing the use of these function in detail on next post. Till then keep digging.

Do not forget to share if you find this post helpful. If you have any comment, please leave and let us know.
John Bhatt

Read More

Keyboard Shortcuts in Microsoft Excel 2003

Hi,

Lets have a look at some keyboard Shortcuts for Microsoft Excel.

Table of keyboard combinations

SN	Key	Action	Alternate
1	Ctrl+A	Select All
2	Ctrl+B	Bold
3	Ctrl+C	Copy
4	Ctrl+D	Fill Down
5	Ctrl+F	Find
6	Ctrl+F	Goto
7	Ctrl+H	Replace
8	Ctrl+I	Ralice
9	Ctrl+K	Insert Hyper Link
10	Ctrl+N	New Workbook
11	Ctrl+O	Open
12	Ctrl+P	Print
13	Ctrl+R	Fill Right
14	Ctrl+S	Save
15	Ctrl+U	Under Line
16	Ctrl+V	Paste
17	Ctrl+W	Close	File,Clse
18	Ctrl+X	Cut	Edit,Cut
19	Ctrl+Y	Repeat	Edit,Repeat
20	Ctrl+Z	Undo	Edit,Undo
21	F1	Help	Help,Contents and Index
22	F2	Edit	None
23	F3	Paste Name	Insert,Name,Past
24	F4	Repeat test action	Edit,Repeat,Works while not in Edit mode
25	F4	White typing a formula, Switch between absotule/reletave rels	None
26	F5	Goto	Edit,Goto
27	F6	Next pane	None
28	F7	Spell check	Tools,Speling
29	F8	Extent mode	None
30	F9	Recaicutate all work book	Tools,Options,Calucation,Cale,Now
31	F10	Active Member	N/A
32	F11	New chart	Insert, Chart
33	F12	Save As	File,Save As
34	Ctrl+ :	Insert Cument Time	None
35	Ctrl+ ;	Insert Current Date	None
36	Cttrl+ "	Copy Value form Cell Above	Edit,Pest Special,Value
37	Ctrl+	Copy Formula form Cell Above	Edit,Copy
38	Shift	Hold down sift for additinaol in Excel's me	None
39	Shiftt+F1	What's This?	Help,What's This?
40	Shift+F2	Edit Cell Comment	Insert, Edit,Comments
41	Shift+F3	Pest function Into formulas	Insert, Function
42	Shift+F4	Find Next	Edit,Next,Find Next
43	Shift+F5	Find	Edit,Next,Find Next
44	Shift+F6	Previous pen	None
45	Shift+F8	Add to selection	None
46	Shift+F9	Calculete active worksheet	Calc Sheet
47	Shift+F10	Display shortcut menu	None
48	Shift+F11	New  worksheet	Insert, Worksheet
49	Shift+F12	Save	File,Save
50	Ctrl+F3	Define Name	Insert Names Define
51	Ctrl+F4	Close	File Close
52	Ctrl+F5	XL Restore window Size	Restore
53	Ctrl+F6	Next workbook window	Window,….
54	Shift +Ctrl+F6	Previous workbook window	Window,….
55	Ctrl+F7	Move window	XL,Move
56	Ctrl+F8	Resize window	XL,Size
57	Ctrl+F9	Minimize workbook	XL,Minimize
58	ctrl+F10	Maximize or Restore window	Xl,Maximize
59	Ctrl+F11	Insert 4.0 Micro Sheet	None Excel 97
60	Ctrl+F12	File open	File,Open
61	Alt+F1	Insert chart	Insert, Chart….
62	Alt+F2	Save As	File Save As
63	Alt+F4	Exit	File,Exit
64	Alt+F8	Micro diloge box	Tools,Micro,Microsins in year Excel 97 Tools,Macros - in earlier version
65	Alt+F11	Visual BasicEditor	Tools,Micro,Bisual Basic Editor
66	Ctrl+Shift+F3	Creat name by presing names  of row and column tables	Insert,Name,Create
67	Ctrl+Shift+F6	Previous window	Window
68	Ctrl+Shift+F12	Print	File,Print
69	Alt+Shift+F1	New worksheet	Insert,Worksheet
70	Alt+Shift+F2	Save	File,Save
71	Alt+=	Auto sum	No direct equivalent
72	Alt+	Toggle value/Formula display	Tool,Options,View,Formulas
73	Ctrl+Shift+A	Insert argument names Into formula	No direct equivalent
74	Alt+Down arrow	Display auto Complete list	None
75	Alt+"	Formula style dialog box	Formet,Style
76	Ctrl+Shift+~	General formet	Format, Sells, Number, Category ,General
77	Ctrl+Shift+!	Comma format	Format, Sells, Number, Category,Number
78	Ctrl+Shift+@	Time Formet	Format, Sells, Number, Category,Time
79	Ctrl+Shift+#	Date formet	Format, Sells, Number, Category,Date
80	Ctrl+Shift+$	Currency formet	Format, Sells, Number, Category,Currency,
81	Ctrl+Shift+%	Persent forment	Format, Sells, Number, Category,Persentage
82	Ctrl+Shift+^	Exponential formet	Format, Sells, Number, Category
83	Ctrl+Shift+&	Place autline border around selected cell	Formet,Cells,Border
84	Ctrl+Shift+_	Remove outlion border	Formet,Cells,Border
85	Ctrl+Shift+	Select current region	Edit,Goto,Special,Current Region
86	Ctrl++	Insert	Insert,(Ros,columns,or Cells)Depends on selection
87	Ctrl+-	Delete	Delete,(Ros,columns,or Cells)Depends on selection
88	Ctrl+1	Formet cell dilog box	Formet,Cells,Border
89	Ctrl+2	Bold	Formet,Cells,Font,Font style,Bold
90	Ctrl+3	Italic	Formet,Cells,Font,Font style,Italic
91	Ctrl+4	Under Line	Formet,Cells,Font,Font style,Underlion
92	Ctrl+5	Strikethrow	Formet,Cells,Font,Effects,Strikethrough
93	Ctrl+6	Show / Hide object	Tool,Options,View Objects,Show All/Hide
94	Ctrl+7	Show / Hide Standerd toolbar	View,Toolbar,Standard
95	Ctrl+8	Toggle outline symbols	None
96	Ctrl+9	Hide row	Formet,Row,Hide
97	Ctrl+0	Hide columns	Formet,Columns,Hide
98	Ctrl+Shift+(	Unhide row	Formet,Row,Underlion
99	Ctrl+Shift+)	Unhide columns	Formet,Columns,Underline
100	Alt or F10	Activet the menu	None
101	Ctrl+Tab	In toolbar : Next toolbsr	None
102	Shift+Ctrl+Tab	In toolbar : Privous toolbar	None
103	Ctrl+Tab	In a workbook : Active next workbook	None

Thanks to +Suresh kumar Awasthi for this collection. If you enjoyed and find this helpful, share this article or leave a feedback.

+John Bhatt 

Read More

Printing Header Rows (titles) in all pages of Microsoft Excel

Hi,

Once again, continuing Microsoft Excel series, I am going to tell you one more useful trick if you are working in office and use Excel for your work.

Introduction

You need to print data that is feeded in  Excel several times, but when data is larger, more than a page at printout, you need to print headers in top of the page. Or you need to print Column fixed in your printout. Earlier we have learnt how to fix columns in excel sheet and rows in excel sheet in previous posts.
Take a look at screenshots below, While we are looking in Print Preview, first page is showing header information in top but while in next page, there is no information, It is hard to know which column is it,

Procedure

Lets move to process directly without loosing time. Look at file we are working with.

1. Click on Page Layout tab.
2. Click on Print Titles command.
3. You will get Page Setup dialogue box open with Sheet tab.
   
    
4. Now Enter the Row numbers followed by Dollar sign ($) in Rows to repeat at top box, you can select using link button in box.
   
5. Click OK to apply settings.

Now look at the Print Preview once again.

Ok, its what you required.
Thanks for reading. If you find this post useful, do share and provide feedback.
+John Bhatt 

Read More