+ Reply to Thread
Results 1 to 4 of 4

inserting numbers in the shapes faster than usual

  1. #1
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    139

    inserting numbers in the shapes faster than usual

    hi guys,
    i wanna to make stickers for children with a bunch of numbers which must be in the stars-shape.the problem is i had to use a lot of time to typing in the numbers onto the shapes and i just wondering how to do it faster.any ideas?please help.

    numbersinshape.xlsx

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: inserting numbers in the shapes faster than usual

    ascending order would not be possible because your names of the stars are not ascending
    however to quickly to do if they were in the right order is by using macro/vba

    Please Login or Register  to view this content.
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    139

    Re: inserting numbers in the shapes faster than usual

    Thanks a lot!!!!

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: inserting numbers in the shapes faster than usual

    cheers thanks for the rep

+ 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. Faster way to categorize data (Faster than nested-if)
    By excel1985 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-05-2014, 01:56 AM
  2. inserting images and shapes using macros
    By Suraj3825 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2013, 03:58 PM
  3. Assign numbers to shapes excel 2007
    By mammagamma in forum Excel General
    Replies: 15
    Last Post: 07-05-2012, 07:59 AM
  4. How To Move Shapes From Another Shapes? (floating shapes)
    By MarcLev in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2009, 04:04 PM
  5. [SOLVED] Can faster CPU+larger/faster RAM significantly speed up recalulati
    By jmk_li in forum Excel General
    Replies: 2
    Last Post: 09-28-2005, 06:05 AM

Tags for this Thread

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