Excel Magic Trick #504: 3D Formatting For Cells Using Borders

9
37




About this tutorial:

Video duration: 2:41
See how to use the Borders tab in the Format Cells dialog box to create a 3D effect to Cells.

9 COMMENTS

  1. If you want to create 3 D effect for only one cell, you could apply thin white border to top and left border, and thick black border to right and bottom borders. It looks like the cell is popping out leaving a shadow behind

  2. Playlist name: Excel Randomizing Tricks

    some videos:

    Excel Magic Trick 276 MoreFunc Excel add-in 66 New functions

    Excel Magic Trick 302: Randomly Select Names No Repeats

    Excel Magic Trick 373: Randomize…

  3. I already have videos on Random picking without duplicates. Go to the excelisfun channel, go to playlist, find the playlist that has randomization tricks. There are two or three videos on "Random picking without duplicates".

  4. Thank you. Is there any chance you could do a video on soccer fixtures etc… i.e from a selection of 10 teams, have random fixtures but have each team play each other but only Once and also have the table update and also have the QF SM AND FINAL Fixtures update. Thank you

    You are awesome and your response is very quick

  5. Try these videos:

    Excel Magic Trick # 273: Extract Top 5 Records w Formula

    Excel Magic Trick 337: RANK function 10 Examples

    Excel Magic Trick 471: Sort Horizontal With Formula 3 Examples

  6. If 2 teams have the same points i want to table to update with the teams with the best goal difference, if that is the same then i want it to update by the team who has scored the most goals, if that is alos the same then i want it to update by the team who has conceded the least.

    i,e (P=PLAYED, W = WON, D = DRAW = L=LOSS, GS = GOALS SCORED, GC = GOALS CONCEDED, GD = GOAL DIFF (GS – GC = GOAL DIFF)

  7. Thank you
    You are the best
    How long did it take you to become an excel expert knowing all these functions? i wish i could be like you 1 day.

    Need some help, im trying to do a soccer table (i .e 6 teams in 1 group, 3 groups altogether). 3 points for a win, 1 point for draw and 0 points for loss). I want to be able to have the table update from 1 to 6 based on whoever has the most points. I can use the rank function however i cant get it to update 1 to 6 in a row.

LEAVE A REPLY

Please enter your comment!
Please enter your name here