+ Reply to Thread
Results 1 to 2 of 2

How to save selected columns as html

  1. #1
    Registered User
    Join Date
    07-14-2014
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    3

    How to save selected columns as html

    Hello all

    I need to save an entire workbook with all contained sheets as .html
    I actually just save as .html (entire workbook) but in the web browser it is difficult to scroll from right to left because the widget is too tiny due to numerous sheets.
    I know i can hide extra empty column or publish only printable area but the web page take toooo looong too looaad...

    Is there another way to limit every sheet from column A to T and then publish to web?

    Many thanks!

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: How to save selected columns as html

    Maybe you need to split a copy of the file (logically) into workable number of pages and have multiple html files instead of one big one. You can insert hyperlinks to navigate to each html page.

    The loading taking a long time is due to file size and hiding columns isn't going to fix that.

    On my laptop 20 columns of normal width is about the max that I can display without scrolling.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. [SOLVED] Save as HTML on close
    By nixxrite in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-03-2013, 03:23 AM
  2. Save workbook as HTML
    By scabral in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-28-2009, 04:43 PM
  3. save to HTML??
    By ADK in forum Excel General
    Replies: 2
    Last Post: 12-03-2005, 08:10 PM
  4. Save as HTML oddity
    By c in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  5. Save as HTML oddity
    By c in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  6. [SOLVED] Save as HTML oddity
    By c in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. Save as HTML
    By Danimagus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-03-2005, 02:05 PM
  8. [SOLVED] save as html
    By writenick in forum Excel General
    Replies: 0
    Last Post: 01-13-2005, 02:06 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