Results 1 to 4 of 4

Shift cells down and keep the formulas the same

Threaded View

  1. #1
    Registered User
    Join Date
    11-24-2016
    Location
    Victoria, Australia
    MS-Off Ver
    2016
    Posts
    14

    Shift cells down and keep the formulas the same

    I'm currently working a sheet which relies on different sets of exported pdf to excel graphs which are all similar however sometimes out by 10 or so rows. I have the formulas set out so when it all works its perfect however sometimes its not and I need to select 5-6 columns in a row and shift the data down. When I do this the formulas change to follow where it would have been originally despite setting the formulas as absolute

    In the attached file for example I want to shift cells down of columns of A to J from the row 610 to be even with the #1 on row 632 however the formula needs to stay the same. Help please
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. day shift overtime and night shift formulas
    By Pranklin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-06-2015, 04:05 PM
  2. Shift time & penalty rate formulas
    By EWATR in forum Excel General
    Replies: 3
    Last Post: 01-20-2015, 10:32 AM
  3. Ctrl+Shift+Enter (CSE) array formulas in VBA using differing formulas
    By officeguy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2012, 04:31 PM
  4. Formulas to autosum shift hours
    By AndyL3 in forum Excel General
    Replies: 9
    Last Post: 07-10-2011, 06:11 PM
  5. how do i shift data but have formulas stay in place?
    By vphreeze in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 06-10-2008, 04:01 AM
  6. shift formulas to the next column
    By bill gras in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2006, 08:15 AM
  7. [SOLVED] Shift formulas, but not formats
    By JoelW in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2005, 05:05 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