14 Excel Formatting Tips (Make Excel BEAUTIFUL!)

Поделиться
HTML-код
  • Опубликовано: 23 дек 2024

Комментарии •

  • @RowlandHetrick
    @RowlandHetrick 3 года назад +13

    For titles across the top I like to use Center across selection. I would block c3:g3 and choose format Center across selection. That way it doesn't interfere with the automatic column width when you double click on the right side of the top column. I also hide columns or rows using Group rows or Group cells. Then if I need to look at something that is hidden I can either click the plus above the hidden cells to expose them or the 2,3,etc at the top left to expose all hidden cells.

  • @HowToAnalyst
    @HowToAnalyst 2 года назад +7

    I typically set the print area (page layout -> print area -> set print area) before sharing. People used to print a lot when everyone was in the office 5 days per week. It's probably still a good idea but I don't think people are printing as often.

    • @TigerSpreadsheetSolutions
      @TigerSpreadsheetSolutions  2 года назад

      Interesting point Pete. I personally hardly ever print, but I know some people who do. Accountants seem to like printing :-)

  • @stevenlagoe7808
    @stevenlagoe7808 3 года назад +7

    Excellent tips, Chris. Using shades of the same colour - I like it!
    I find when I'm designing a spreadsheet I tend to concentrate on the 'mechanics' of it too much and don't pay enough attention to how the front end looks. After-all, it's my baby, I've built it, I've spent hours staring at the bloody thing, I know what the output looks like and where to look for the data I need. It’s all obvious to me. So, with a spreadsheet to be used solely by me I would pay almost no attention to formatting. WRONG!
    I’ve tripped myself up so many times by returning to one of my spreadsheets that I’d written ages ago, and…I have to spend half an hour trying to work out where everything is!
    From now on I’m going to constantly ask myself the question: ‘Is what I’m doing 'visually obvious' to the untrained eye?’
    Thanks again.
    p.s.
    I’m getting back into keyboard shortcuts, thanks to you. Frustrating to begin with but once you get used to them they’re so much cooler than using the mouse!

  • @laramccully3272
    @laramccully3272 2 месяца назад +2

    Thank you so much for this video. I LOVED everything you showed here.🙏🏼😊

  • @orlahastings4563
    @orlahastings4563 Год назад +1

    This video just popped up on my feed. Really helpful tips thank you. Will be checking out your channel!

    • @TigerSpreadsheetSolutions
      @TigerSpreadsheetSolutions  Год назад

      Thank you Orla and welcome to the channel - we have a whole playlist just on Excel formatting, enjoy!

  • @henrikijonkoping4694
    @henrikijonkoping4694 3 года назад +2

    Good, this took me to the next level. Have a nice weekend!

  • @AhmadKadi10
    @AhmadKadi10 3 года назад +4

    Great tips, I wish you mentioned how to do each action by choosing from the menu not just by shortcuts..

    • @TigerSpreadsheetSolutions
      @TigerSpreadsheetSolutions  3 года назад +1

      Hi Ahmad - I tried to include as many explanations as possible, whilst keeping the video short. If it wasn't clear, Google will help you find the answers. Good luck!

    • @mason8714
      @mason8714 9 месяцев назад

      i was about to say the same. great video but far to many short cuts :) am working on the web version and alot of them dont work :) but thanks for all the tips

  • @annog6673
    @annog6673 2 года назад +4

    I adviseagainst hiding columns and instead group them (in the data tab). That makes it more obvious. (Except of course the columns outside the model for ctr + r action).

    • @TigerSpreadsheetSolutions
      @TigerSpreadsheetSolutions  2 года назад

      Interesting - I don't personally like the additional complications on the interface that grouping creates with the buttons etc.

  • @alanbosher2728
    @alanbosher2728 3 года назад +4

    Chris. You talk a lot about keyboard shortcuts. I find right click and context menus a very efficient tool e.g. to insert, delete, hide, unhide rows and columns.

    • @TigerSpreadsheetSolutions
      @TigerSpreadsheetSolutions  3 года назад +1

      Alan - it's a personal thing perhaps but I just find using the keyboard is much faster than the mouse ...

  • @TSSC
    @TSSC 3 года назад +8

    For consistent formatting:
    1. Change the default font (no need for per cell font selection).
    2. Use Excel tables to format tabular data (quick and enables simplified referencing). A custom style can be created if you don’t like the built-in ones and the workbook contains many tables for which you want consistent formatting.
    3. Use cell styles (define/redefine if needed).
    4. If printing: define print area, header/footer, and related properties.

  • @brucesagide4492
    @brucesagide4492 3 года назад +4

    Excellent. Though I personally find it very disappointing how uneasy it is to work with Freezing and Unfreezing. For instance in this case, if the table is created a few rows and columns into the spreadsheet, it removes the ability to freeze the first rows and columns in the table.
    If Microsoft would develop more flexible freezing capabilities, navigating through large spreadsheet content would be majorly efficient, while at the same time allowing for major formatting possibilities.

    • @TigerSpreadsheetSolutions
      @TigerSpreadsheetSolutions  3 года назад +2

      Thanks Bruce - I think you're talking here about a kind of 'layered' freeze pane capability. Sounds cool!

  • @Belligol_Rma5
    @Belligol_Rma5 7 месяцев назад +1

    Excellent video learnt a lot and thanks for clearly explaining.

    • @TigerSpreadsheetSolutions
      @TigerSpreadsheetSolutions  7 месяцев назад

      It's a pleasure and welcome to the channel - see you in another video in this series!

  • @loganpedroza7493
    @loganpedroza7493 2 года назад +1

    Awesome video! Thank you so much for sharing these tips!

  • @radheshyamthakur
    @radheshyamthakur 2 года назад +1

    Really nice shortcuts in full action

    • @TigerSpreadsheetSolutions
      @TigerSpreadsheetSolutions  2 года назад

      Thank you - shortcuts are so important for efficient Excel usage, I highly practising them ...

  • @alishainc
    @alishainc Год назад +2

    this is gold, I'm lost on excel

    • @TigerSpreadsheetSolutions
      @TigerSpreadsheetSolutions  Год назад

      Welcome to the channel, Alisha - we're releasing a follow-up to this video this week or next ...

  • @trustabyss
    @trustabyss 4 месяца назад +1

    I keep my spreadsheets simple. Printer toner isn't cheap, and to add color, gets expensive. My preference is a simple black and white table with bold headers and bold total row. Everything else is regular font for the data.

  • @bleuaqua8102
    @bleuaqua8102 11 месяцев назад +1

    I needed this, thank you!

  • @tyroneashby5420
    @tyroneashby5420 3 года назад +1

    Another brilliant video ,thanks Chris

  • @danielhampton4844
    @danielhampton4844 2 года назад +1

    HOW CAN I ADD A CHARACTER (SPACE OR LETTER) AFTER EVERY NUMBER IN A MIXED JUMBLE OF LETTERS AND NUMBERS IN A SINGLE CELL?

    • @TigerSpreadsheetSolutions
      @TigerSpreadsheetSolutions  2 года назад

      By 'parsing' out the contents of the cells into single cells, then concatenating them together
      ruclips.net/video/BH85f2ey8Rk/видео.html

  • @britt6579
    @britt6579 Год назад +1

    This was incredible! So easy to follow and so informative. Thank you!

  • @Anu-zq8mu
    @Anu-zq8mu 2 года назад +1

    Thanks for this brilliant video sir.

  • @dattallfoo
    @dattallfoo Год назад +1

    Love it, thank you!

  • @Atarian6502
    @Atarian6502 10 месяцев назад +1

    Q: Which of these spreadsheets would you rather work with?
    A:The FIRST one. Definitely the first one! The second one looks much nicer, agreed. But that works for the final presentation of the data. Not for working with the data. Absolutely not :) Nice tips by the way. Thank you!

  • @saurabh9416
    @saurabh9416 3 месяца назад

    Thank you so much.

  • @a.caglar
    @a.caglar Год назад +1

    It turned out better than the first one, but it could have been much better.

  • @jarlathmcardle3359
    @jarlathmcardle3359 10 месяцев назад +1

    The training is way to quick in the explanations as for example the column header description action - " ALT H FS9 " what ?

    • @TigerSpreadsheetSolutions
      @TigerSpreadsheetSolutions  10 месяцев назад

      It's not 'training' as such - it's a RUclips video which is why the pace is fast. Google will give you a list of Excel keyboard shortcuts if you did not pick them up.
      Thanks for watching and good luck with your Excel learning!

  • @TigerSpreadsheetSolutions
    @TigerSpreadsheetSolutions  3 года назад +1

    🔥WATCH NEXT
    🔥14 MORE Excel Formatting Tips
    ruclips.net/video/xxxcOKFHoFA/видео.html

  • @dalpati1
    @dalpati1 2 года назад +1

    good tips to implement

  • @peerawatkupatilertpong8793
    @peerawatkupatilertpong8793 2 года назад +1

    Nice tips

  • @VishalChakravartyDevil
    @VishalChakravartyDevil 3 года назад +1

    Data cleaning please

  • @tommyharris5817
    @tommyharris5817 3 года назад +8

    I hate Arial; Calibri is more relaxed and just looks more professional

    • @TigerSpreadsheetSolutions
      @TigerSpreadsheetSolutions  3 года назад +2

      It's a matter of opinion, I suppose. But, I think changing the default font does show you've made some additional effort.

    • @laramccully3272
      @laramccully3272 2 месяца назад

      I hate both of those fonts.😂
      On a quest to find the best font to use in Excel! (For my personal taste)😉

  • @VishalChakravartyDevil
    @VishalChakravartyDevil 3 года назад +1

    Amazing

  • @fitnesstips_Navid
    @fitnesstips_Navid 2 года назад +3

    Very confusing when you mention the shortcuts!

    • @TigerSpreadsheetSolutions
      @TigerSpreadsheetSolutions  2 года назад

      I think shortcuts are an important part of Excel practice because they really speed up your operation of Excel, that's why I mention them

    • @EverMoreDesign
      @EverMoreDesign 7 месяцев назад +1

      I disagree. I loved learning new shortcuts. To be a power user in ANY software application you must learn keyboard shortcuts.

  • @tryme113
    @tryme113 Год назад +1

    beautiful

  • @ARoseReigns
    @ARoseReigns 3 месяца назад

    God i hate using excel with a passion and my job requires me to use it for any and everything, this is what i needed. Still hate it though

    • @Matt-rw9py
      @Matt-rw9py Месяц назад

      I love excel. I use It for my personal finances. Love it a lot

  • @s_mblogs2250
    @s_mblogs2250 Год назад +1

    Supperrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr video

  • @lissilva
    @lissilva Год назад +3

    Too fast! Ugh🙄🤦🏻‍♀️

    • @TigerSpreadsheetSolutions
      @TigerSpreadsheetSolutions  Год назад +2

      0.5 speed?

    • @EverMoreDesign
      @EverMoreDesign 7 месяцев назад +1

      I disagree, you can play back slower .5 or even .25. Most tutorials are way too slow and I have to run them at 1.75 or even 2.0 speed. Good job!

    • @ChrisBanda
      @ChrisBanda 5 месяцев назад

      He flies through the keyboard shortcuts because the're second nature to him, most of us beginners and casual users do not have that level of dexterity lol

  • @xenna1143
    @xenna1143 Год назад +1

    Real designers would NEVER use Arial!!! YUCK!!!