Comments on: Excel table styles and formatting: how to apply, change and remove

After you have created a table in Excel, what's the first thing you would like to do with it? Make it look exactly the way you want! Luckily, Microsoft Excel provides a variety of predefined table styles that let you apply or change the table formatting in a click. Continue reading →

Table of contents

Comments page 2. Total comments: 55

  1. Svetlana Cheusheva you are so sweet....

  2. When printing a table, is there a way to double space the rows (without inserting blank rows or increasing the row height)? Thanks.

  3. how can i hide my formula in excel sheet .... nobody see the formula....

  4. hello!
    Mam,

    i want to know . how can i use index formula in multiple cell?

  5. How types of data validation?

  6. Hello...
    I have two tables on same sheet (side by side) i.e. the rows of both the tables remains same. So when i filter the data of one table, the data on other near by table too changes which i don't expect it to do. Note that i don't want to place the tables one below another & want both tables on same sheet side by side.

    Hope there will be solution to it.....

    Thanks & Regards,
    Merang

    1. Just put one (small or hidden) column between the two tables

  7. hi Svetlana Cheusheva
    please can you tell me about how to delete pivottable in ms excel functional
    thansk

    1. Hello ! sir

      In the Excel window, click anywhere inside the PivotTable report.
      Under Pivot Table Tools, on the Options tab, in the Actions group, click Select, and then click Entire PivotTable.
      Press the Delete key.

  8. How may I convert a TXT file into excel WITHOUT creating the table or query format. I do not want it formatted as a table or a query, jsut a simple conversion to excel 2016. Or how can I remove the query and table formatting features once converted. It does not allow you to sort the entire page and the queriesa re not helpful if you do not need a table

  9. Worked a charm! Thank you.

  10. I am using a table format. When I add a line under the table i.e. the next row, it automatically extends the table along with all formats. Unfortunately the table has the date formatted to US instead of the UK (the rest of the logical world, in fact!). How can I change the format of the auto-generated rows? I can only seem to format the table from a visual perspective and now the cells themselves. At the moment I extend the table and then change the time format manually. Please advise,

    Thanks.

    1. *visual perspective but not the cells themselves.

  11. Very helpful tips!!!

  12. Hi!!

    Whenever I import data from SQL server blue shaded table style if selected by default.
    I need some other style. Even if I set it as default, still every time data is imported the blue shaded table comes to effect.

    Please suggest.

  13. Hi,

    When the table comes from an external database (ie sql server in my case) , each update of the database turns off all my formattings.

    How to disable this (the same we can do in a pivot table)

  14. Hi,

    I've been searching with no luck, if there is a way in which a custom table style o custom pivot table style can become the default style for every other workbook created after that.

    1. Stefan:

      Did you ever find an answer?

  15. Hi
    I have a question for you.
    I have a database and the phone cell is write like this (623)700-4388 but I need get simple form like this 6237004388. Do you know if I can change this the list is big.. and I do not want to do this manually.

    1. Hi Diego,

      You can use Excel's Find and Replace command (Replace All), and replace the opening and closing parenthesis as well as the dash with nothing.

      Or, you can do the same using the SUBSTITUTE function:

      =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"(",""),")",""),"-","")

      1. Hello Svetlana

        Just want to say you are so smart!! I did not realize find&replace can actually do a lot of things!!!! Thank you for some idea, and hope I could apply that in future. :D

  16. Hi Svetlana Cheusheva,

    I have nearly 200 employees log in in log out details with different shift timing. Everyday the employee will come to the work at different shift, how to find out that the employee has come to the duty at correct time or not by using ms excel. We have 3 shifts. Morning to afternoon, afternoon to night and night to morning. For instance, today an employee called A came in the morning shift at 6 am and then tomorrow coming in the afternoon 2 pm and then the following day coming at night 10 pm..I wanna find out, whether he came to the shift to correct time or not and how many hours he worked. Can you give some idea in this regard?

    1. Hello, just a thought, can you not give the poor employee a normal shift pattern? That might make it a lot easier for both of you!

  17. Container Size
    State 20 40
    Sydney 520 730

    How to pick value with two condition i-e
    Sydney & 20 = 520 , Sydney & 40 = 430

    1. Hello Asad,

      You can use nested If's with embedded AND statements, like this:

      =IF(AND(B1=20, A2="sydney"), 520, IF(AND(B1=40, A2="sydney"),430, ""))

      If you are looking for something different, please clarify.

  18. How To Insert If Condition On Time Format

    1. Hello Aanand,

      Sorry, it's impossible to advise anything based on such a generic description. Can you please elaborate on the task a bit more?

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)