Microsoft Office Forums - View Single Post - Get actual record to stay

Thread: Get actual record to stay

View Single Post

Old

02-28-2018, 04:32 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

On the Data Sheet

Highlight >> B3:B9
Select F5 >> Special
Toggle blanks >> OK
Select the equal sign >> up arrow >> Ctrl + Enter
Highlight column B >> copy >> pastespecial as values

Reply With Quote