Tuesday, May 28, 2013

2010 Version Excel Keyboard Shortcuts List Begin With [ALT] + [Other Keys]

If you are seeking for Excel shortcut key for comply with any of your particular sake. Here is the place for you to take a glance and pick the one you like. In addition, you can save our site as your remark for the future visit.

This is the list of Excel version 2010 shortcut way by using keyboard key beginning with "ALT" key button for the main key and plus together with another key(s) like letters, numbers, comma, period, semicolon, arrow keys, Caps Lock key, control keys, function keys, page up, page down, command key button and more.

Benefits:

• Mouse will be never used for this shortcut key. Therefore, you can say good-bye to your mouse from now on. Why we bring thing unless we can leave it at its home?
• It is very simply way to get the outcome instantly.
• It is great deal for Excel users having alternative to handling worksheets.
• Spend less of your time. Nevertheless, vice versa save your energy.

Table Excel shortcut key starting with [Alt] and plus another keys:

Excel Shortcuts
Result
ALT+' (APOSTROPHE / SINGLE QUOTE) To display the style dialog box.
ALT+= To insert the autosum formula. Then input array of cells in it.
ALT+A ... ALT+Z In dialog box, to select an option, or select or clear a check box.
ALT+ARROW DOWN In the Excel dialog box, to display the autocomplete list such as in cell with dropdowns or Auto Filter.
ALT+ARROW DOWN Display in the Auto Filter list for the current column on the field with column head.
ALT+ARROW DOWN To open the selected drop-down list in the dialog box.
ALT+ARROW UP Closing the Auto Filter list for the current column.
ALT+B To set bottom border. (Cell Format in 'Border' dialog window).
ALT+C To move the selected field into the "column area" (In Pivot Table).
ALT+D To move the selected field into the "data area" (In Pivot Table).
ALT+D To set diagonal and down border. (Cell Format in 'Border' dialog window).
ALT+E THEN L To delete current worksheet (Permanent delete).
ALT+E THEN M To move or copy current worksheet (Display menu box).
ALT+ENTER Start a new line in the same current activated cell.
ALT+F1 To create and insert chart with data in range of current cells selected.
ALT+F10 Selecting the active tab of the 'Excel Ribbon Tap' and activate the access keys. Just key Alt+F10 gain to cancel.
ALT+F11 Opening the visual basic editor to create macros.
ALT+F4 To close excel workbook. (Don't forget to save your latest updated file before use this tip).
ALT+F8 To display the macro dialog box that prompt to input macro name.
ALT+H THEN AC To align data center.
ALT+H THEN AL To align data in cell left.
ALT+H THEN AR Align data right.
ALT+L Display the Pivot Table field dialog box.
ALT+L To set left border. (Cell Format in 'Border' Dialog window).
ALT+O(LETTER) THEN HR Rename current worksheet.
ALT+P To move the selected field into the page area in Pivot Table.
ALT+PAGE DOWN To move one screen to the right in a current worksheet.
ALT+PAGE UP To move one screen to the left in a current worksheet.
ALT+R Move the selected field into the row area in Pivot Table.
ALT+R To set right border. (Cell Format in 'Border' Dialog window).
ALT+SHIFT+ARROW LEFT To ungroup rows or columns.
ALT+SHIFT+ARROW LEFT To ungroup selected Pivot Table items.
ALT+SHIFT+ARROW RIGHT To group rows or columns.
ALT+SHIFT+ARROW RIGHT To group selected Pivot Table items.
ALT+SPACE To display the control menu for main excel window e.g. restore, move, size,..
ALT+T To set top border. (Cell Format in 'Border' Dialog window).
ALT+U To set diagonal and up border. (Cell Format in 'Border' Dialog window).

Michael Leng is Thai, has a BA in Hotel management from Ramkhamhaeng University. He had worked for some hotels. Currently he works in logistics field, Bangkok, Thailand. Because of loving in English,  he has written some his own blogs in English-he really wants any feedback about his English he has posted.

See more another tips:
You might like my another blogs:

Excel Trick “A Keystroke” Make Space Between Combine Text Data In Different Cell

When we use some excel formula such as formula to combine the data entered of each cell to together. The regular formula that we usually use are: “CONCATENATE” and “&”.

However, somebody who use the mentioned formula above may frustrate that the data entered of each active cell are connecting together completely. There are no space between each group of the data entered.

This is the example of the using 'CONCATENATE (A1, A2, A3)' formula:

Suppose the data in each of the three active cells as below:


A1 [Sales Accumulation]
A2 [Sales Forecast]
A3 [Actual Sales]

Then we put the active cell names into the formula: = CONCATENATE (A1, A2, A3)

# Result: Sales AccumulationSales ForecastActual Sales

See that the three group of word are connected without any room space.

Here we go to the trick for making space accordingly.

Just add more formula symbols "Double Quotation Mark"[ " " ] between the cell name in a formula, press an [Enter] button one time inside the "Double Quotation Mark"[ " " ] too.

Saturday, May 25, 2013

Contact

What
It is 
Blog writer
Michael Leng
E-mail address
wlapanikorn@gmail.com

Shortcut Trick and Tip for Microsoft Excel Office Software Program


Microsoft Excel is developed by Microsoft. It has the basic features of all spreadsheets. It’s worked by ordering through tools on the ribbon. Likewise, we are able to use the “Shortcut” to save time and apply its functions to support our requirements.

To share my acknowledges about Excel through my blog to everyone who might interesting in it. Excel not only works according to the function tools, but also the shortcut.  I usually use Excel for my daily jobs. Pivot table, formula (Particular “=If(..,..,..)”) , graph, screen shot are the most tools which I have been using.

Sometimes I am so nervous when the new assignments have came up just out of the blue. Since, I don’t know lots of Excel formula to finish my works (Inventory report) as soon as possible. How so good if I were very prompt at getting assignment done without taking a long time! I have begun to study Excel function through Excel manual books, Excel online teaching sites, Excel template from my colleagues.

Now, I am confident of my Excel acknowledges as a user. Some of my friends and colleagues come to see me and asking for help in Excel problems solving, Excel tips, Excel shortcuts and apply formula of Excel or the way to get the expected outcome.

Even currently, The Excel program have been creating and developing for many versions. The latest version is V.2013.  It is composed by lots of functions to support for jobs in offices, particularly the calculation formula and tools. But, in my blog which I have been posting and sharing right here is talking about V.2010

I apologize if there were some mistake and error about my words and/or information.

All suggestions are welcomed.

Monday, May 6, 2013

[Concatenate] Or [&] Excel Formula Gathering The Data Entered In The Active Cells

Do you know the method of congregation the data entered from cells?

Well, I have two methods for gathering the data entered from each active cell to set into the only one place. To use these formulas to pick up data as you want and link them together in a chain or series into just a single active cell in a worksheet.

Here we go to the two ways respectively.

1. Formula ‘CONCATENATE’

= CONCATENATE (text1, text2, text3,)

Example:

Supposing there are the data entered in each cell as:

A1 [Sales Accumulation]
A2 [Sales Forecast]
A3 [Actual Sales]

Replace the active cell names into the formula:

= CONCATENATE (A1, A2, A3)

Result: Sales AccumulationSales ForecastActual Sales

[Click! Kindle Fire HD Tablet - Power by Amazon.com]

2. Formula ‘&’

= text1 & text2 & text3 &,

Example:

Let’s say the data entered in the active cells follow are as:

B1 [Total students]
B2 [Students present]
B3 [Actual absence]

To input the cell names to the series of formula as:

= B1&B2&B3

Result: Total studentsStudents presentActual absence


Hope the kits might help you!

See more another Excel shortcuts:


Sunday, May 5, 2013

How To Calculate Amount Of The Current Active Cells In Column Of Excel ? | "Exceltip2day"

In Excel, not only calculate the sum amount of figure/number, but also result the amount of active cells that having the data(number) in them. 


The result will give us to know that how many cells which containing the numbers we are using them.

This Excel formula will skip counting if those cells are blanked or having another data beside the number(s).

Here below is a formula:

= COUNT(A first reference cell : An end  reference cell ).

Pertaining the mentioned formula above will be used for count the amount of cell(s) in column (s)/row (s) within the range declare in a formula. Not capable for counting alphabet, symbol, empty cell(s) entered into the cells.

For example, all the cells in the column from A1 to A8 below being filled out with the contents as shown:

No.of column&cell
A
1
ABC
2
_ _ _
3
xyz
4
456
5
@#*(
6
_ _ _
7
_ _ _
8
Ax45*)

=COUNT(A1:A8)

For example: if you select all the cells above and apply the formula , the number "1" should come up as the result. Because the formula ignored the empty cells and all other cells that they have non-number in them.

Therefore, the current column is counted into the ONLY cell:

A4 {456}

These 7 cells following will not comply to the "Count (xx... : xx...)" formula.

A1 {ABC}, A2{---}, A3 {xyz}, A4 {456}, A5 {@#*(}, A6{---}, A7{---}, A8 {Ax45*}  

See the image of the result after the formula proceeded as below for more understanding:


The "Count (cells range)" formula can be used by a single & multiple columns/rows or in a range of cells in an Excel spreadsheet.

Bye,
Michael Leng,

See more:
You might like my another blogs: