+ Reply to Thread
Results 1 to 3 of 3

Help with how to set rows inside a worksheet

  1. #1
    Registered User
    Join Date
    04-13-2015
    Location
    Western part of USA
    MS-Off Ver
    2010
    Posts
    2

    Help with how to set rows inside a worksheet

    Hello,

    I am a novice Excel user, but hope to become more experienced over time. I apologize in advance for not knowing the correct terminology to best describe what I am looking for.

    I need some help in figuring out how to set up my Excel worksheet for an exercise/workout plan. I will try my best to explain what I need help with by describing how I have set up my exercise plan.

    I want to keep track of how many minutes I spend on a cardio machine, how "far" I went, what the level/incline/intensity was, and my heartrates (AVG and MAX) for each day of the week except Sunday (that's my off day to let my body rest).

    There are 8 columns on one worksheet (I am using two cardio machines, but for this question/explanation, I am just going to do one as an example). The columns are as follows day of week, date, level, minutes, AVG steps/min, total steps, AVG HR and MAX HR. I skipped Sunday because there will be no info there. Since I want to cut and paste the paper into a small spiral notebook to take with me to the gym, I made four blocks with two weeks per block. That way, I can cut each block to fit the small piece of paper in the notebook. The rows are like this... there are fourteen (14) rows per block and the first two rows of each block are the same. The first two rows contain the name of the machine, the column headers (previously mentioned a couple of sentences ago). The other 12 rows contain the day of the week, date, level, etc., etc., etc. If I want to eliminate a week (because of vacation, illness, or work), I can simply cut the 6 days from the date column and move everything up.

    The problem when I move the days up, the first two rows of each block moves up too. How can I make the first two rows of each block stay the same and not move at all while moving the rest of the data in that particular column up (but not the first two rows of each block)?

    Does that make sense? Can anyone help me? I'd appreciate any feedback anyone has on this issue.

    Thank you very much.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Help with how to set rows inside a worksheet

    Select that desired range and Insert Cells so that moved cells will get moved to the actual place


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    04-13-2015
    Location
    Western part of USA
    MS-Off Ver
    2010
    Posts
    2

    Re: Help with how to set rows inside a worksheet

    Sixthsense ,

    Thank you for your response. Can I select multiple rows with gaps in between all at the same time? Like, for example, I can select the first seven rows,
    then skip the next three then do seven rows then skip the next 5 then cut and insert into where ever I want and the rows that I skipped will stay where they
    were before the insertion? I don't want to mess up the rows or the ones I want to stay in the same place/rows. Does that make sense?

    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. CountIF inside of different worksheet with a filter
    By Tom005 in forum Excel General
    Replies: 13
    Last Post: 06-06-2014, 08:07 AM
  2. [SOLVED] How to lock and unlock worksheet using a password but inside worksheet change event
    By BeachRock in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2014, 06:55 PM
  3. A graph for each worksheet placed inside the pertained worksheet
    By puddles in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-16-2013, 12:17 AM
  4. Inserting a UserForm inside a Worksheet
    By cgi_pro in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-14-2006, 12:20 AM
  5. Need help on deleting rows . Please see inside.
    By quekou in forum Excel General
    Replies: 1
    Last Post: 02-24-2006, 11:14 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1