+ Reply to Thread
Results 1 to 3 of 3

any way to clear the formatting of a row just to the right of the table it's in?

  1. #1
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    Excel 2010 14.04.4760.1000
    Posts
    468

    any way to clear the formatting of a row just to the right of the table it's in?

    is there a way to clear the formatting of a row just to the right of the table it's in?

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: any way to clear the formatting of a row just to the right of the table it's in?

    Not 100% sure this is what you mean, but...

    If your table is in A1:J200, and you want to clear the formatting from column K to the end (right side) of the worksheet for just row 18, then select cell K18. While holding down CTRL+SHIFT, tap the right arrow key. As long as there are no cells with data to the right, this will select K18:IV18 (or K18:XFD18 for newer versions of Excel with more columns). You can then adjust or clear the formatting of those cells. (Home > Editing > Clear > All | Formats | Contents.. etc.)

  3. #3
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    Excel 2010 14.04.4760.1000
    Posts
    468

    Re: any way to clear the formatting of a row just to the right of the table it's in?

    hmm.. maybe it's my older version of excel that's the problem but hitting right at the end does nothing, but left causes the selection to go from the entire row to just the cells WITHIN the table. Maybe someone else will know...

    no biggie, I'm just cleaning it up and otherwise I'll have to clear the whole rows then reformat them and I used to have a habit of formatting entire rows.
    Excel 1.0.1 (16.0.14326.20140) (Android)
    Excel 2010 14.04.4760.1000

+ 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. Move data from 1 table to another table, then clear the original table
    By kwoltman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-03-2019, 06:06 PM
  2. How to write VBA code to clear a table but preserve table and 1 empty row
    By kwoltman in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-28-2019, 07:26 PM
  3. excel can't clear formatting
    By random379 in forum Excel General
    Replies: 3
    Last Post: 10-01-2013, 02:37 AM
  4. clear number formatting
    By carmie in forum Excel General
    Replies: 4
    Last Post: 06-13-2012, 04:58 PM
  5. clear me the doubt in copnditional formatting
    By N.sangeetha in forum Excel General
    Replies: 3
    Last Post: 05-23-2012, 10:50 AM
  6. Clear Cell Value and Change Formatting.
    By newbie1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-15-2012, 09:21 PM
  7. Add cell formatting to Clear macro?
    By dillinger in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-26-2010, 09:31 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