Friday, August 10, 2018

Ctrl + ' (apostrophe) To Fill Cell Formulas Down From The Adjacent Cell Above | Exceltip2day


Hello there.

I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about:

Ctrl + ' (apostrophe)



Tip Quiz


What is the shortcut key to select the entire worksheet or the data-containing area?


In Excel worksheet, if you have filled some formulas into a cell. And if you want to use those formulas again, but for the cell which is beneath them.

You just only the 2 keys as the shortcut to operate it as the instruction as follows:


Shortcut for:  To fill cell formulas down and edit.

Windows shortcut


Ctrl  '


To let you see more in the clear picture, take a look the figures describe all steps below:


👉  In the cell B2, it contains the formula syntax  " =1+1" (Take a look the figure no. 1)


Ctrl + ' (apostrophe) To Fill Cell Formulas Down From The Adjacent Cell Above | ExcelTip2Day  ExcelTip2Day-Shortcut, Trick and Solving Methods Excel tip, how to fix, shortcuts, how to handle Excel problem by yourself
Figure no. 1 Show the formula = 1+1 in cell B2

👉 In this step, pay attention to the cell B3. For this step, just press the 2 keys Ctrl + ' into the cell B3 and move your fingers out of them.


How to use Ctrl + ' (apostrophe) To Fill Cell Formulas Down From The Adjacent Cell Above | ExcelTip2Day  ExcelTip2Day-Shortcut, Trick and Solving Methods Excel tip, how to fix, shortcuts
Figure no.2 Show how to use the shortcut key Ctrl + ' in the cell B3

👉 In this last step, take a notice in the cell B3. You will see the formula which is as the same as the cell B2.


Show you step by step how to use Ctrl + ' (apostrophe) To Fill Cell Formulas Down From The Adjacent Cell Above | ExcelTip2Day  ExcelTip2Day-Shortcut, Trick and Solving Methods Excel tip, how to fix, shortcuts
Figure no.3 Show the result of the same formulas as the above cell.



Tip Answer

 a. It uses the keys Ctrl + B.

 b. It uses the keys Ctrl + A.

 c. It uses the keys Ctrl + C.


Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

Link recommended👉 : English Numbers In Words 1 to 1000000


That brings me to the end of my posting.

Before I am about to say goodbye to you, I hope that what I have posted and shared with you today. They will be beneficial for you, your company, and any relevant.

If you love it, I will be happy. If you share this with your friends, I will be shiny.

I hope to receive any feedback from you guys. Because they will be such treasures--any error in this blog--for future improvement.

Does it help?

Thanks for reading.

Bye,

Posted by: Michael Leng



I've known, then I've grown.
See more articles:

Monday, July 23, 2018

4 Aspects Deleting: How To Use Keyboard Shortcut [Ctrl]+[-] (Minus) | ExcelTip2Day


Hello there!

I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about:

How to use "Ctrl" + "-"(Minus)



Tip Quiz


How to delete all the objects in an Excel worksheet?


In my article today, I'm going to show you how to use the shortcut key and its 4 deleted options for Excel users to select according to his/her aspects.

All the 4 options are as following;


Delete "Shift cell left"

Delete "Shift cell up"

Delete "Entire row"

Delete "Entire column"


Notify:

Please use it with care, it may cause your related data, such as formulas, table,  border...

In case of wanting to resume your last action, you can redo (Ctrl + Y) and undo (Ctrl + Z) to fix it.

My article consists of 4 parts.

👉 1st part: 

In the first part, you will see the "Tip Quiz" box questioning the beneficial about an Excel tip. Of course, I guess you have seen it already as it is in the prior paragraph above.

👉 2nd part: 

On the second part, now I will show you the shortcut excel keys to use for deleting cells, columns, and rows in 4 different purposes.

Windows shortcut 



Ctrl -


👉 3rd part:


Refer to the shortcut from the 2nd part, here I'll describe and also show you all 4 purposes of deleting works.

Figure number 1. This is the scenario figure that I have prepared for you to be understood them more easily.

It contains the 10 rows and 5 columns. In the mid, cell d5:d7, is the mark for future proceeding the "Ctrl" + "-".


Figure no. 1

Let' have a look the figure no.2 below, once I have pressed the "Ctrl" + "-" buttons, the square box " Delete?" will instantly show as you can see it in the image.

Then, I have selected the choice "Shift cells left"


Figure no. 2

The figure no. 3 shows us the result after I clicked on the "OK" button. The 3 cells from left columns move to replace the previous cells d3:d7.



Figure no. 3

Let's move to the figure no. 4. In this image, I have selected the round checkbox "Shift cells up".


Figure no. 4

The figure no. 5. You can see the result after I deleted by "Shif cells up". The figure explains it very well, right?


Figure no. 5

The figure no. 6 below shows us how to delete by the "Entire row".


Figure no. 6

What's the figure no. 7 tell us. Good job! The row no. 4-6 have gone.


Figure no. 7

This is the last deleting aspects. It's the "Entire column" delete.


Figure no. 8

Hooyah, the entire column no. 3 has been disappeared. And the meantime, all the columns from the left moved and replaced respectively.


Figure no. 9


👉 4th part:


The tip answer, this is for you to find your best choice. Also, you can check both its answer and data source.


Tip Answer

 a. Use the shortcut key " ALT" + "Select Object"


 b. Use the shortcut key "Ctrl" + "Select Object"...


 c. Use the shortcut key " Shift" + "Select Object".



Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

Link recommended👉 : English Numbers In Words 1 to 1000000


Now, that's the end of my presentation.

Thanks for reading.

Bye,

Posted by: Michael Leng



I've known, then I've grown.
See more articles:

Monday, June 1, 2015

How Can I Calculate Any Date In Excel Worksheet? - Check Formula “=today()” | Exceltip2day



How to calculate "date" in Excel?



YOU! Do you know that in Excel office program having a function calculate “DATE”?


Yes, the function of date value calculation is formed with the syntax “=today()”


The benefits of this formula:


It will give an automatically value of the “CURRENT DATE” whenever it is loaded,-auto refresh.


The following is the step handling the function:


👉 Click into any cell in your Excel worksheet.

👉 Fill out the syntax formula =today().

👉 Edit the formats to display as your determine.

Fill out =today() into any cell.

The result is given as the DATE shown.

The "Format Cell" function for edit your format.


Does it help?



Hopefully, this today's formula post is beneficial for you.

See you again.

Thanks for reading.

Posted by:Michael Leng



I've known, then I've grown.



See more other tips:

Sunday, May 31, 2015

How To Use "=NOW()" Formula And Get Current Date And Time (Varies) In Excel | Exceltip2day



See how to use "NOW()" formula in Excel


How To Use "=NOW()" Formula And Get Current Date And Time (Varies) In Excel- ExcelTip2Day-Shortcut, Trick and Solving Methods Excel tip, how to fix, shortcuts
Figure 1. Shown the prospect cell to show the current date and time

In this post, you will see how to use the "=NOW() Formula"

Previously, if someone questioned me, “How will I get such as the "Updating Current Date And Time" as the mention above?” I would doubt.

How about you?

Don't worry. Today I'm going to show you how to obtain it.

Hello everyone. My name is Leng, You can see me and my posts about Excel tips, shortcuts, and how to fix any error here--through my blog "ExcelTip2Day"


In the Excel office program, there are many formulas and functions to help users to handle their job easily.

Today, this blog, “Exceltip2day”, is going to describe to you the method of how to find out the “Current Date and Tine” with formula in an Excel worksheet.

The following is the syntax of Excel formula to use for sending out the result of  “Current Date and Tine”

=now()

The benefits of this formula:

It will give the automatically updating date and time whenever that Excel sheet file is opened, - auto refresh.

How to use it step by step below:


👉 1 step:

 Select your prospect cell in your Excel spreadsheet (See figure no.1) 


👉 2 step:

Fill out the formula immediate below inside it (See figure no. 2) 

=now()


See the image below for more easier understanding.

Figure 2. Shown the "=now" syntax formula is entered in cell B3



Figure 3. Shown the return of a Date Value.

There, you will see the result, the Current Date shown in the cell B3 already.  Yet, if you would like to show more the Current Time as well. Thus, you have to custom your format cell to dd/mm/yyyy h:mm as per the figure no. 4 below.


Figure 4. Shown how to custom the Current Time.

Right here, the final result of our tips on how to use the "=NOW()" Formula, showing you the completed Date and Time actively.


Figure 5. Shown the Current Date and Time.



Hope the tip on how to use "=NOW()" Formula will be useful for you accordingly.




Do you know?


What to do if your monitor screen upside down?

 a. Pressing the Ctrl + Alt + Up Arrow.

 b. Pressing the Ctrl + Alt + Down Arrow.

 c. No, I have never heard of this issue before.


Link recommended ðŸ‘‰How Can I Calculate Any Date In Excel Worksheet? - Check Formula “=today()”

Link recommended ðŸ‘‰Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

Does it help?

What do you think?

Before I am about to say goodbye to you, I hope that what I have posted and shared with you today. They will be beneficial for you, your company, and/or any relevant.

If you love it, I will be happy. If you share this with your friends, I will be shiny.

And, I hope to receive any feedback from you guys. Because they will be such treasures--any error in this blog--for future improvement.

See you again.

Thanks for reading.

Posted by: Michael Leng



I've known, then I've grown.

See more other tips: