Forum Discussion

oceanguy1's avatar
oceanguy1
Copper Contributor
Jan 22, 2020

Column border help

Hi everyone, First time poster here. Just have a question, I have a large table and had to edit the borders in a particular column. To get it uniform before changing it I highlight the entire colum...
excel
office 365
PascalKTeam's avatar
PascalKTeam
Iron Contributor
Jan 22, 2020

Hi oceanguy1 

 

select the cell below the table which needs to be changed (remove border or whatever), press Ctrl+Shift +↓ to select all cells in this column from the first you want to change to the bottom one. 

 

Now make the change to the border

  • oceanguy1's avatar
    oceanguy1
    Copper Contributor
    Jan 23, 2020
    Thank you! It work
    • PascalKTeam's avatar
      PascalKTeam
      Iron Contributor
      Jan 23, 2020
      Fantastic! Please mark my answer as accepted solution

Resources