+ Reply to Thread
Results 1 to 4 of 4

Table Tools how can I find them and better yet, how can I avoid needing to use them

  1. #1
    Registered User
    Join Date
    01-17-2012
    Location
    Pacific Northwest
    MS-Off Ver
    Excel 2019
    Posts
    87

    Question Table Tools how can I find them and better yet, how can I avoid needing to use them

    Normally, I can add a row and it is automatically included in a way that I can sort and the new row is automatically included. Someone here was kind enough to point out that I needed to "RESIZE" my table now because at some point there's a break in my sheet and a number of rows below that break keep hiding. I've tried scrolling down so that I can see all the rows and "Resize" again but they were immediately hidden again until I scroll down to see them.

    Now when I try to "Resize": I click on a cell (above the break) but Table Tools does not even appear. I've included a screenshot.

    I'd very much like to get out of what ever "mode" I've accidentally activated and go back to simply adding a row that is included in my sorts and not hidden somewhere in the middle.

    Your assistance would be greatly appreciated!
    Attached Images Attached Images

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,872

    Re: Table Tools how can I find them and better yet, how can I avoid needing to use them

    Hi and welcome to the forum

    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    01-17-2012
    Location
    Pacific Northwest
    MS-Off Ver
    Excel 2019
    Posts
    87

    Re: Table Tools how can I find them and better yet, how can I avoid needing to use them

    Thanks for your reply. It was my hope that by showing a screen shot, someone could tell me which of my available options would lead me to Table Tools. From what I've read, all I should need to do is select a cell within the currently sized table and then table tools would magically appear.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Table Tools how can I find them and better yet, how can I avoid needing to use them

    You have to put the cursor in one of the cells in the table.

    => design => change tablesize

    After that you problem should be solved.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. Needing a macro to Find, Select, Copy if...
    By bjc124 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-28-2020, 10:38 AM
  2. [SOLVED] Needing help with find and add between dates type formulas
    By Prof Sick in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-09-2020, 08:53 AM
  3. Where to find more info about each Library from the Tools-References
    By IonutC in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2016, 04:16 AM
  4. Needing to find ways of automating simple processes
    By maxraph in forum Excel General
    Replies: 5
    Last Post: 01-20-2012, 06:12 AM
  5. needing to find largest value in array, then return entire row associated with result
    By Phraedrique in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-15-2009, 12:32 PM
  6. Cannot find Tools Menu
    By Joe Miller in forum Excel General
    Replies: 2
    Last Post: 02-13-2009, 03:35 PM
  7. Tools for Excel Table
    By jacksonmathews in forum Excel General
    Replies: 0
    Last Post: 08-23-2007, 11:57 PM

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