+ Reply to Thread
Results 1 to 4 of 4

How do you insert rows into multiple sheets in a workbook?

  1. #1
    Marketing Queen
    Guest

    How do you insert rows into multiple sheets in a workbook?

    I have an excel workbook that is 145 sheets large. Most of the sheets have
    cells with reference points to the first sheet. I need to add a row to EACH
    sheet in the same location. Is it possible to add a row to each sheet with
    one basic command or do I have to do it on EACH individual sheet?

  2. #2
    Pete_UK
    Guest

    Re: How do you insert rows into multiple sheets in a workbook?

    You can group all your sheets together, so that whatever you do to one
    sheet is done to them all - you must remember to ungroup them at the
    end.

    Assuming all your sheets are contiguous, then click on the first sheet,
    hold down SHIFT and click on the last sheet. (If they are not
    contiguous you will have to hold down CTRL instead of SHIFT and click
    on each one). Then you can highlight the row in the visible sheet and
    Insert | Row - this will be inserted at that position in every sheet
    which is part of the group.

    To ungroup the sheets right-click on one of the sheet tabs.

    Hope this helps.

    Pete


  3. #3
    David Biddulph
    Guest

    Re: How do you insert rows into multiple sheets in a workbook?

    "Marketing Queen" <Marketing Queen@discussions.microsoft.com> wrote in
    message news:15269E91-C23E-4441-94C5-63FC0D21F5F3@microsoft.com...
    >I have an excel workbook that is 145 sheets large. Most of the sheets have
    > cells with reference points to the first sheet. I need to add a row to
    > EACH
    > sheet in the same location. Is it possible to add a row to each sheet
    > with
    > one basic command or do I have to do it on EACH individual sheet?


    Select all the tabs, then if you do an insert on one it will apply to the
    others.
    --
    David Biddulph



  4. #4
    Registered User
    Join Date
    11-17-2015
    Location
    Stockholm
    MS-Off Ver
    2010
    Posts
    1

    How do you insert rows into multiple sheets in a Google Drive workbook?

    I have the same problem as above but I need to do it in an Excel file in Google Drive.

    I have an excel workbook in Google Drive that has 40 sheets. All of the sheets have cells with reference points to the first sheet. I need to add a row to EACH
    sheet in the same location. Is it possible to add a row to each sheet with one basic command or do I have to do it on EACH individual sheet?

    Any tips and tricks?
    Last edited by peosta; 11-17-2015 at 11:40 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.05731 seconds
  • Memory Usage 8,887KB
  • Queries Executed 16 (?)
More Information
Template Usage (31):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (4)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (4)postbit_legacy
  • (1)postbit_onlinestatus
  • (4)postbit_wrapper
  • (4)showthread_bookmarksite
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (40):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php
  • ./includes/functions_prefix.php 

Hooks Called (46):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • memberaction_dropdown
  • reputation_image
  • postbit_imicons
  • tag_fetchbit_complete
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1