Skip to main content

Posts

Showing posts from May, 2014

Excel Trick Expand Excel Column Width Fit To The Longest Data Entered.

In Excel worksheet, the active cells with the data entered (numbers, letters, symbols, etc.) inside. Those scattered data entries, which are added and contained to cells, may have variety of length. The data in each cell that is narrower or wider than the typical columns width. If you want to expand the column width (AutoFit Column Width), equal the longest data in the cells of all columns in the worksheet. I have a trick. Let us explore it together. For example, see the image below: Notice that in all the columns between A and D contain with some different data entered. However, we will not see all the text inside these cells. Because, the column widths in this worksheet are set to the standard length. Therefore, if you want to see all the text, data entered, in each cell and every column as well. That means you must expand the width of all columns fit to the longest text that will cut off if the cells to the right contain data. According to the above imply, hereafte

Ctrl+-(minus sign) Excel Shortcut Open Dialog Box Menu of Delete Cells, Row and Column Function

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about how to use the shortcut keys: Ctrl] + - Tip Quiz What is the shortcut edit active cell and positions the insertion point at the end of the data entered? In Excel worksheets, it allows you to deal with the four functions of Delete in the DELETE dialog box as below: Delete Shift Cells Left Delete Shift Cells Up Delete Entire Row Delete Entire Column The figure shows the returning result after use [Ctrl] + [-] Shortcut method to display the Delete Dialog box: Press the “Ctrl” button and keep hold of it. Press the “-” (minus sign). Then, release the two buttons as mentioned above lines. Shortcut for:  To open the dialog box menu of the delete cells, row and column Windows shortcut Ctrl - Tip Answer  a.  It's a F2.  b.  It's a F3.  c.  It's a F4.   Answer:   a. Wow! you made it.   Check:  Shortcut Edit Active Cell And Positio

4 Cool Ways To “Sum” Values Of Number In An Excel Worksheet – ExcelTip2day

How do you sum values in an Excel worksheet? How many ways do you know to deal with it? Which way do prefer most? Forget it if you are thinking about the answer. Today, I bring you the four ways of sum values in a worksheet that you can pick to use it as yours. Look at images for your own illustrate practice. i. To use Ξ£ (Sigma sign) Click on cell [A7] Click on [Ξ£] symbol ii. To use the two shortcut key Click on cell [A7] Click on [Alt] [=] iii. Use formula “ =SUM() ” Click on cell [A7] To type [=] [sum] [(]; {equal sign (=), a formula (sum) and an open parenthesis ( ( )} Use mouse click and select cells [A1] to [A6] To type [ ) ]; {a close parenthesis} iv. Use plus (+) and type on cell manually. Click on cell [A7] Type [=] [A1+A2+…A6] Hope you would love one out of four ways to calculate yours number. To me, I like to use the second method. I think it is cool. See more another tips: How To Use AVERAGEIF Formula "Not" Including “0” (

How To Use [AVERAGEIF] Formula "Not" Including “0” (Zero) In Range

Concept: To set up formula of AVERAGEIF into the cell to auto calculate the average sales amount for the whole year while update data in every month (Year To Date). Syntax of AVERAGEIF formula function: =AVERAGEIF (range, criteria, average_range) Range: Required (Must fill out). One or more cells to average, including data entered such as arrays, numbers, names, or references that contain numbers. Criteria: Required (Must fill out). The criteria in the form of a cell reference, number(s), expression, or text that defines which cells are averaged. For example, criteria can be expressed as 123, "123", "<>123", ">123", "Student", "BlogMaster" or A1. Average_range: Optional (Non-compulsory). The actual set of cells to average. If it’s omitted, range is used. Example: In column, B2-E2 they have been being felt the sales amount as: B2 = 200, C2 = 230, D2 = 252, E2 = 232 In column F2-M2 are empty. In co

Shift+Spacebar Excel Tip How To Select The Entire Row of Excel Worksheet | ExcelTip2Day

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to tell you how to use the shortcut keys: Shift + Space bar Let's see more details below. Tip Quiz Do you know the shortcut key to edit active cell instantly? Do you know what to do if you need to select the whole cells in a row? There are two ways to operate as I am going to tell you now below: πŸ‘‰   1] To click on the number of any row to be selected. For example, if we want to select the row no. 5, therefore, hover your mouse over, which are you wanting to and click on it such as the row no. 5 as shown you as the image below. Figure no.1 Show how to click on a row no.5 Addition:  If you would like to select for multiple rows. You can move your mouse cursor to click on any number of rows at the farthest left hand as much as you want. For example, if you want to select the row no. "1" to no. "19", move the mouse cursor and click

3 Tricks (9 Steps) To Adjust Excel Worksheet Screen Size As 'Zoom In' And 'Zoom Out'

Let’s see the 3 methods to do for “Zoom In” and “Zoom Out” Excel worksheet as below; 1] To use "Ctrl" and "Scroll Wheel" button. Step by step for “Zoom In” • Press "Ctrl" button and keep it hold on. • Roll "Scroll Wheel" forward. Step by step for “Zoom Out” • Press "Ctrl" button and keep it hold on. • Roll "Scroll Wheel" backward. 2] To use Mouse moving the "Zoom Slider" as method below; • Right-click Mouse onto "Zoom Slider" and move to the RIGHT side for “Zoom In” • Right-click Mouse onto "Zoom Slider" and move to the LEFT side for “Zoom Out” 3] To use function "Zoom" in the “Ribbon Tab” as step by step below: • Click Tab "View" at the Ribbon • Click command "Zoom" • To adjust the percentage of “Zoom” as you want Thanks for reading. Bye, Posted by: Michael Leng I've known, then I've grown. See more articles: Monitor

Shortcut Keys How To Fixing Window Screen Accidentally 'Upside Down' | ExcelTip2Day

"How do you fix your Window Screen Upside Down?" Hello there! My name is Michael. Welcome everyone to blog. Is it good to know some tip how to fix your PC screen upside down accidentally? Why do I post this article?  Because I have faced this trouble before while I have taught one of my friend typing on the PC. Then after I have spent too much to solve this kind of problem I would like to share with anyone who might come up with this such a magic case!!! Screen 'Upside Down' Fixing In this post, you will see how to fix the " Unintentionally Upside Down Monitor Screen " Tip Quiz Is there any shortcut to minimize an Excel Workbook? If someone questioned me, “How will I able to fix such as the error  as the mention above?” I would doubt. How about you? Don't worry. Today I'm going to show you how to solve it. Hello everyone. My name is Leng, You can see me and my posts about Excel tips, shortcuts, and how to fix any error he