ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   HOW DO I DRAG AND DROP W/O TAKING CELL BORDER? (https://www.excelbanter.com/excel-worksheet-functions/64931-how-do-i-drag-drop-w-o-taking-cell-border.html)

don perkins

HOW DO I DRAG AND DROP W/O TAKING CELL BORDER?
 
HOW DO I DRAG AND DROP W/O TAKING CELL BORDER?

Dave Peterson

HOW DO I DRAG AND DROP W/O TAKING CELL BORDER?
 
Right click and drag down.

Select Fill without formatting

Or just copy the cell
select the "receiving" cells
edit|paste special|formulas

don perkins wrote:

HOW DO I DRAG AND DROP W/O TAKING CELL BORDER?


--

Dave Peterson


All times are GMT +1. The time now is 01:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com