You are searching about Excel Use The Answer From Another Cell In New Formula, today we will share with you article about Excel Use The Answer From Another Cell In New Formula was compiled and edited by our team from many sources on the internet. Hope this article on the topic Excel Use The Answer From Another Cell In New Formula is useful to you.
Muc lục nội dung
Excel Tip – How To Insert Blanks Into Every Other Row In Your Excel Data
This is a regular question or issue that seems to arise with Excel users, (well it does for me anyway).
How to insert a blank line in every other row of your data set? There are many solutions available that require the user to write some code or a macro, which is all well and good, but some users are not comfortable with VBA. There is an easy way to achieve similar results in Excel without the need to write VBA. But I can give you some code to do the same thing… if you want.
Ok let’s insert some blank rows into our data set. Our data set is set out as an extract below.
Date: Week: Day: Weekday: User
01/06/15 1 1 11 AmyH
02/06/15 1 2 12 JoeP
03/06/15 1 3 13 PeterH
05/05/15 1 5 15 SuseM
First we need to insert a new column to the left of the existing column A. (We are assuming that our existing data starts in A1), so our data is now included in column B by inserting a new column A.
The next step is to enter the number 1 in cell A1 and highlight column A in the last row of your data set.
You can press CTRL+SHIFT+DOWN ARROW once to do this quickly. (Click it down twice to select entire columns, including cells with no data. You’re welcome for an extra Excel shortcut tip!.
-
Select the Home tab – Go to the Editing group Select Fill Series
-
Press OK on the fill series.
-
Column A should now be filled with numbers from 1 to the total number of rows at the end of your data set.
-
CTRL+C to copy pasted values
-
Go to the next free cell under your data chain
-
Press CTRL+V to paste the values
-
Highlight the entire data field, including the new rows that appear in column A
-
Home Tab – Sort and Filter – Smallest to Largest in Column A
Your blank lines will be inserted—in a flash!
Then you can delete the auxiliary column A created in the first steps of the process and you are done. Excel uses the number of rows to enable blank rows to be inserted into a worksheet without any VBA programming.
Video about Excel Use The Answer From Another Cell In New Formula
You can see more content about Excel Use The Answer From Another Cell In New Formula on our youtube channel: Click Here
Question about Excel Use The Answer From Another Cell In New Formula
If you have any questions about Excel Use The Answer From Another Cell In New Formula, please let us know, all your questions or suggestions will help us improve in the following articles!
The article Excel Use The Answer From Another Cell In New Formula was compiled by me and my team from many sources. If you find the article Excel Use The Answer From Another Cell In New Formula helpful to you, please support the team Like or Share!
Rate Articles Excel Use The Answer From Another Cell In New Formula
Rate: 4-5 stars
Ratings: 9716
Views: 89125487
Search keywords Excel Use The Answer From Another Cell In New Formula
Excel Use The Answer From Another Cell In New Formula
way Excel Use The Answer From Another Cell In New Formula
tutorial Excel Use The Answer From Another Cell In New Formula
Excel Use The Answer From Another Cell In New Formula free
#Excel #Tip #Insert #Blanks #Row #Excel #Data
Source: https://ezinearticles.com/?Excel-Tip—How-To-Insert-Blanks-Into-Every-Other-Row-In-Your-Excel-Data&id=9053071