+ Reply to Thread
Results 1 to 2 of 2

Template Formatting Problems

  1. #1
    Registered User
    Join Date
    09-13-2016
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    24

    Template Formatting Problems

    My questions are regarding an excel template I have edited.

    Please see my file attached.

    1) Cannot delete columns vertically part of the template
    2) B16 - When I try to change the start date as 30 for 30th it gives me 302 and cannot delete
    3) Cloumn A - When I deleted original text it gave me Column2 and cannot delete
    4) Cannot remove formatting error on column AG

    Thanks for your help
    Attached Files Attached Files
    Last edited by Bright55; 06-24-2018 at 09:42 PM. Reason: attachment

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Template Formatting Problems

    Your template is a Structured Table, and it is restricting you from doing certain things.
    Click on B4, look at the top of teh menu, click Table Tools, then click Convert To Range (under Tools

    Repeat for B10 and B16

    Also, please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. (Victoria is not an excel version )
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Problems with my template page, Inconsistent changes when changing styles
    By JimmyWilliams in forum Word Formatting & General
    Replies: 0
    Last Post: 08-28-2017, 10:57 PM
  2. Creating a PPT presentation - Problems with Template / slide layout
    By EchoPassenger in forum PowerPoint Formatting & General
    Replies: 4
    Last Post: 03-17-2017, 10:50 AM
  3. 2 problems to solve - Automatically generated template
    By Maraug in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2012, 10:46 AM
  4. Problems With Sum function working when using macro to add in template
    By neil__g in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-22-2012, 06:09 AM
  5. Competition template...If statement problems.
    By skyping in forum Excel General
    Replies: 2
    Last Post: 08-27-2010, 03:29 AM
  6. Problems with template in excel
    By geneconley in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2005, 02:05 PM
  7. Replies: 2
    Last Post: 06-20-2005, 06: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